P
Porous Metals Limited
what is the formula for converting a time from 14.58 to read 2:35 pm?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
time.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
P
Porous Metals Limited
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.
format. We divide the 60 minutes of the hour into 100 minutes, so each
minute is 1.67, which is causing me the grief.
B
Bob Phillips
=A20/24
and format as time
--
HTH
RP
(remove nothere from the email address if mailing direct)
and format as time
--
HTH
RP
(remove nothere from the email address if mailing direct)
R
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
=14.58/24 formated as time
will return
2:34 PM (note: I belive time does not round up in Excel)
HTH
RES
B
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)
=ROUND(14.58*60,0)/60/24
--
HTH
RP
(remove nothere from the email address if mailing direct)
B
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)
=ROUNDUP(14.58*60,0)/60/24
--
HTH
RP
(remove nothere from the email address if mailing direct)