Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To in Excel
How do I convert the end result (total) to actual hours and minuets worked?
Sample: 2.07 .30 .35 1.10 .10 .59 .15 Totals 4.66 Note: the above amounts represent hours and minuets worked every day and then totaled at the end of the week. I need to know how to convert this in a basic method to total actual hours and minuets worked (the true answer is 5 hours and 46 min)...Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To in Excel
=TIME(INT(A1),MOD(A1,1)*100,0)
Copy down and SUM Result: 5:46 -- Kind regards, Niek Otten Microsoft MVP - Excel "JR" wrote in message ... | How do I convert the end result (total) to actual hours and minuets worked? | Sample: 2.07 | .30 | .35 | 1.10 | .10 | .59 | .15 | Totals 4.66 | | Note: the above amounts represent hours and minuets worked every day and | then totaled at the end of the week. | I need to know how to convert this in a basic method to total actual hours | and minuets worked (the true answer is 5 hours and 46 min)...Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |