Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time
I want to add a column of times in a time sheet. I can get the hours worked
but can't seem to get the column to add totalhours |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time
You haven't explained exactly what the problem is but if your times are in
hours/minutes (hh:mm) then ensure the "total" cell is formatted as [h]:mm. The total should be a simple =SUM(A1:A100). "jfw-Florida" wrote: I want to add a column of times in a time sheet. I can get the hours worked but can't seem to get the column to add totalhours |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time
I have a time sheet with column a as start then b is finish and c is total
time. No problem with b-a=c using hh:mm but when I try to sum col c into a total the answer is not shown as hh:mm. I have tried everything from general thru custon and the answer is not correct "Toppers" wrote: You haven't explained exactly what the problem is but if your times are in hours/minutes (hh:mm) then ensure the "total" cell is formatted as [h]:mm. The total should be a simple =SUM(A1:A100). "jfw-Florida" wrote: I want to add a column of times in a time sheet. I can get the hours worked but can't seem to get the column to add totalhours |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time
Just saying it is "not correct" isn't helping anyone to answer your problem.
What numbers are you adding, and what answer does Excel display when you format the answer as [h]:mm? -- David Biddulph "jfw-Florida" wrote in message ... I have a time sheet with column a as start then b is finish and c is total time. No problem with b-a=c using hh:mm but when I try to sum col c into a total the answer is not shown as hh:mm. I have tried everything from general thru custon and the answer is not correct "Toppers" wrote: You haven't explained exactly what the problem is but if your times are in hours/minutes (hh:mm) then ensure the "total" cell is formatted as [h]:mm. The total should be a simple =SUM(A1:A100). "jfw-Florida" wrote: I want to add a column of times in a time sheet. I can get the hours worked but can't seem to get the column to add totalhours |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time
OK - it is a simple time sheet Line one column a is start time say for a Monday
line to column a is start time for Tuesday etc Column b is the end time for each day and column c is the total hoursw worked for the day. If each day worked is 8 hours then the total of column c must be 40 hours 0 minutes. I used the formula =b-a to get the number of hours worked for each line or day in column c. Then I wanted to sum all the hours worked for column c which as I said must equal 40 - but the number displayed when using hh:mm is 16.00. "David Biddulph" wrote: Just saying it is "not correct" isn't helping anyone to answer your problem. What numbers are you adding, and what answer does Excel display when you format the answer as [h]:mm? -- David Biddulph "jfw-Florida" wrote in message ... I have a time sheet with column a as start then b is finish and c is total time. No problem with b-a=c using hh:mm but when I try to sum col c into a total the answer is not shown as hh:mm. I have tried everything from general thru custon and the answer is not correct "Toppers" wrote: You haven't explained exactly what the problem is but if your times are in hours/minutes (hh:mm) then ensure the "total" cell is formatted as [h]:mm. The total should be a simple =SUM(A1:A100). "jfw-Florida" wrote: I want to add a column of times in a time sheet. I can get the hours worked but can't seem to get the column to add totalhours |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time
That's what we'd expect if you use hh:mm. What happens when you use the
format [h]:mm, as suggested? -- David Biddulph "jfw-Florida" wrote in message ... OK - it is a simple time sheet Line one column a is start time say for a Monday line to column a is start time for Tuesday etc Column b is the end time for each day and column c is the total hoursw worked for the day. If each day worked is 8 hours then the total of column c must be 40 hours 0 minutes. I used the formula =b-a to get the number of hours worked for each line or day in column c. Then I wanted to sum all the hours worked for column c which as I said must equal 40 - but the number displayed when using hh:mm is 16.00. "David Biddulph" wrote: Just saying it is "not correct" isn't helping anyone to answer your problem. What numbers are you adding, and what answer does Excel display when you format the answer as [h]:mm? -- David Biddulph "jfw-Florida" wrote in message ... I have a time sheet with column a as start then b is finish and c is total time. No problem with b-a=c using hh:mm but when I try to sum col c into a total the answer is not shown as hh:mm. I have tried everything from general thru custon and the answer is not correct "Toppers" wrote: You haven't explained exactly what the problem is but if your times are in hours/minutes (hh:mm) then ensure the "total" cell is formatted as [h]:mm. The total should be a simple =SUM(A1:A100). "jfw-Florida" wrote: I want to add a column of times in a time sheet. I can get the hours worked but can't seem to get the column to add totalhours |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time
Thanks David - that did the trick - never worked with time before and had no
idea about the formulas thanks again! Frank "David Biddulph" wrote: That's what we'd expect if you use hh:mm. What happens when you use the format [h]:mm, as suggested? -- David Biddulph "jfw-Florida" wrote in message ... OK - it is a simple time sheet Line one column a is start time say for a Monday line to column a is start time for Tuesday etc Column b is the end time for each day and column c is the total hoursw worked for the day. If each day worked is 8 hours then the total of column c must be 40 hours 0 minutes. I used the formula =b-a to get the number of hours worked for each line or day in column c. Then I wanted to sum all the hours worked for column c which as I said must equal 40 - but the number displayed when using hh:mm is 16.00. "David Biddulph" wrote: Just saying it is "not correct" isn't helping anyone to answer your problem. What numbers are you adding, and what answer does Excel display when you format the answer as [h]:mm? -- David Biddulph "jfw-Florida" wrote in message ... I have a time sheet with column a as start then b is finish and c is total time. No problem with b-a=c using hh:mm but when I try to sum col c into a total the answer is not shown as hh:mm. I have tried everything from general thru custon and the answer is not correct "Toppers" wrote: You haven't explained exactly what the problem is but if your times are in hours/minutes (hh:mm) then ensure the "total" cell is formatted as [h]:mm. The total should be a simple =SUM(A1:A100). "jfw-Florida" wrote: I want to add a column of times in a time sheet. I can get the hours worked but can't seem to get the column to add totalhours |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) |