| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
