Thread: How To in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR JR is offline
external usenet poster
 
Posts: 92
Default 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