convert time value of 14.58 to 2:35 pm

[Guest]

what is the formula for converting a time from 14.58 to read 2:35 pm?

 

[Anne Troy]

You don't need a formula. You should just be able to format the cell as
time.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Thanks Anne. I tried that though, and it gives me back a different time
format. We divide the 60 minutes of the hour into 100 minutes, so each
minute is 1.67, which is causing me the grief.

 

[Bob Phillips]

=A20/24

and format as time

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Robert_Steel]

Have a look in the help at how Excel handles times and dates

=14.58/24 formated as time

will return
2:34 PM (note: I belive time does not round up in Excel)

HTH
RES

 

[Bob Phillips]

If you need it rounded up, use

=ROUND(14.58*60,0)/60/24

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

I mean rounded. Rounded up would be

=ROUNDUP(14.58*60,0)/60/24


--

HTH

RP
(remove nothere from the email address if mailing direct)