| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round hh:mm:ss to whole hh:mm
I am using the following:
=TEXT((J30/$B$31)/24, "h:mm") to convert hours and hundreths to hours and minutes. Excel is dropping the seconds and not rounding up. (e.g., 9:00:36 should round to 9:01) Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round up a function RESULT | Excel Discussion (Misc queries) | |||
| hh:mm - mm formated 2 round to .25, .50, .75 & 1 | Excel Worksheet Functions | |||
| Round a number in nested function | Excel Worksheet Functions | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Threaded Mode
