| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to Minutes
Converting 5:08:00 using =(HOUR(D2) *60)+MINUTE(D2) works perfect.
That turns out 308 minutes. However, converting 119:38:00 the same way doesn't work. As a matter of fact, HOUR(XN) where the value of the cell XN = 119:38:00 returns 23. It should be 119. How can I convert 119:38:00 to 7178 minutes? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Time to Hours & Minutes | Charts and Charting in Excel | |||
| Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
| converting a number to time formatted as minutes | Excel Worksheet Functions | |||
| Time - converting HH:MM:SS to Minutes | Excel Worksheet Functions | |||
Threaded Mode
