Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert time value of 14.58 to 2:35 pm
what is the formula for converting a time from 14.58 to read 2:35 pm?
|
#2
|
|||
|
|||
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 "Porous Metals Limited" wrote in message ... what is the formula for converting a time from 14.58 to read 2:35 pm? |
#3
|
|||
|
|||
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. "Anne Troy" wrote: 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 "Porous Metals Limited" wrote in message ... what is the formula for converting a time from 14.58 to read 2:35 pm? |
#4
|
|||
|
|||
=A20/24
and format as time -- HTH RP (remove nothere from the email address if mailing direct) "Porous Metals Limited" wrote in message ... what is the formula for converting a time from 14.58 to read 2:35 pm? |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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) wrote in message ... 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 |
#7
|
|||
|
|||
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) "Bob Phillips" wrote in message ... 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) wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Text Time to Time | Excel Discussion (Misc queries) | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
How do I convert Military Time to minutes? | Excel Worksheet Functions | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) |