Converting Decimal to Time Sequence

bmils · Oct 21, 2003

I need to convert a decimal calculation to a time sequence.
For instance
I need 1.33 to read as 1.20 meaning 1 hour and 20 minutes.
Any help would be appreciated.
Thanks

John Viescas · Oct 21, 2003

Format((DecTimeCalc / 24), "hh.nn")

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411

Gary · Oct 21, 2003

Multiply 1.33 by 1:00 G

Converting Decimal to Time Sequence

bmils

John Viescas

Gary