Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time sheets and hours
I set up a timecard for myself, in which I input a start and end time, and
through subtraction, arrive at a number of hours worked. A B C 1 9:00 AM 5:00 PM 8.00 2 8:30 AM 5:00 PM 8.30 3 TOTAL: 16.30 Trouble is I get funky totals, because, I suspect, the C column is giving times instead of a number of hours. So it's adding 8:00 am to 8: 30 AM and telling me I only worked a half hour. Any ideas? The total should be total hours worked. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time sheets and hours
Format Column C to General or Number, and use this formula:
=(B1-A1)*24 If you anticipate that you might cross midnight, where the end time is less then the start time, try this instead which works for *all* cases: =MOD(B1-A1,1)*24 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jaytee" wrote in message ... I set up a timecard for myself, in which I input a start and end time, and through subtraction, arrive at a number of hours worked. A B C 1 9:00 AM 5:00 PM 8.00 2 8:30 AM 5:00 PM 8.30 3 TOTAL: 16.30 Trouble is I get funky totals, because, I suspect, the C column is giving times instead of a number of hours. So it's adding 8:00 am to 8: 30 AM and telling me I only worked a half hour. Any ideas? The total should be total hours worked. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time sheets and hours
Make sure that columns A and B are formatted as Time and that C is not (set
it General or Number with set number of decimal places) and when you do the math in column C multiply the result by 24, as: =(B1-A1)*24 Excel handles times as you're using them as fractions of a day, so 5pm - 8am actually returns a value of .375, which multiplied by 24 gives 9 "Jaytee" wrote: I set up a timecard for myself, in which I input a start and end time, and through subtraction, arrive at a number of hours worked. A B C 1 9:00 AM 5:00 PM 8.00 2 8:30 AM 5:00 PM 8.30 3 TOTAL: 16.30 Trouble is I get funky totals, because, I suspect, the C column is giving times instead of a number of hours. So it's adding 8:00 am to 8: 30 AM and telling me I only worked a half hour. Any ideas? The total should be total hours worked. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time sheets and hours
Thanks! Very helpful. Now I can get paid!
"Jaytee" wrote: I set up a timecard for myself, in which I input a start and end time, and through subtraction, arrive at a number of hours worked. A B C 1 9:00 AM 5:00 PM 8.00 2 8:30 AM 5:00 PM 8.30 3 TOTAL: 16.30 Trouble is I get funky totals, because, I suspect, the C column is giving times instead of a number of hours. So it's adding 8:00 am to 8: 30 AM and telling me I only worked a half hour. Any ideas? The total should be total hours worked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas for Time Sheets | Excel Worksheet Functions | |||
Time Sheets (Yes, I've already done a search on previous posts) | New Users to Excel | |||
Time sheets | Excel Worksheet Functions | |||
Time Sheets | New Users to Excel | |||
Time Sheets | Excel Discussion (Misc queries) |