Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Up My Time (minutes)
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Up My Time (minutes)
Well, I think a simple =sum() would be in order. If you're dealing with time
sheets, look at this template: http://www.vertex42.com/ExcelTemplat...timesheet.html -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Kimbe" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Up My Time (minutes)
Sorry, I meant:
=a1/60/24 Regards, Fred "Fred Smith" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Up My Time (minutes)
In cell A 1 I have:-
Employee1 In cell B 1 I have:- Employee2 In cell C 1 I have:- Employee3 In cells A 2 down to A 25 inclusive I enter:- 30 This is the number of minutes that Employee1 has worked. In cell A 26 I have the following formula:- =SUM(A2:A25)/60 This returns (shows in cell A 26) the number 12 - being the 12 hours worked by Employee1. Copy the above to other cells as required. If my comments have helped please hit Yes. "Kimbe" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing minutes and seconds | Excel Worksheet Functions | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
Summing Hours and Minutes | Excel Discussion (Misc queries) |