Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a field in time format of hh:mm:ss, which I've custom formated to [m]
to get total duration minutes. My problem is I need the seconds to round up if they are more than 30. Is there a way to do this? I use this field for conference call billing, if that helps. Example: 47:05:35 formated to [m] reads 2825 and I need it to read 2826 -- Tess |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. | Excel Worksheet Functions | |||
Excel Time Duration Formula | Excel Worksheet Functions | |||
Smart subtotals | Excel Worksheet Functions |