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
|