View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Summing Up My Time (minutes)

If you're entering time in minutes (as a decimal number), you can convert it
to an Excel time with the following formula:
=a1/60/60
Format as time.

Then just sum the numbers.
If your numbers add up to more than 24 hours, use a format of [hh]:mm to
display it.

Regards,
Fred

"Kimbe" wrote in message
...
I am having a problem figuring this out and I'm sure it is quite simple and
maybe I am trying to hard but I have a worksheet that an employee enters
how
many minutes they worked on something. Each employee has a separate
column
that they enter their time. What I want to do is sum up all their time
(minutes) to produce the total hours and minutes for that particular task.

Any help would be greatly appreciated.