Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |