Thread: How To in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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