View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EAB1977 EAB1977 is offline
external usenet poster
 
Posts: 39
Default Hour function equivelent help

If I want to find out how many minutes there are for times that I have
summed, I know I can use the hour function if the compiled time is
less than 24 hours. But, what if I want to get the times that are over
a 24 hour period, how do I do that?

Example:

20:57:46
14:39:10
8:57:24
12:12:12
-------------
56:46:32 <-- the minutes I'd like to get