How To in Excel

[Guest]

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

 

[Niek Otten]

=TIME(INT(A1),MOD(A1,1)*100,0)

Copy down and SUM

Result: 5:46

--
Kind regards,

Niek Otten
Microsoft MVP - 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