| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I round off times in Excel?
I am calculating times by dividing a distance by a speed. The results are in
cells formatted hh:mm but always seem to be rounded down so that the sum of the column may be several minutes out, compared to the times displayed. If I reformat the cells hh:mm:ss then I can see for example what was 01:32 displayed as 01:32:57. I want this to appear as 01:33. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I nest a ROUND within a IF in Excel? | Excel Worksheet Functions | |||
| How can i add times in Excel? | Excel Discussion (Misc queries) | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
| How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
