If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel calcalation
I am attempting to set up a spreadsheet to monitor time worked. I changed
the cells for the time format, ie. 06:00. I need cells for the following, start time, end time, total time worked, hours over 8 hours, (for overtime). I have been able to get the time worked from the end time - start time. I also like to keep a cell for a running total of the time for the week. When I hit the 3rd day, it does not add anymore, in fact it subtracts a random figure from the total. The actual hours worked is correct. If anyone would like to see what I have, I can email it. Thanks |
#2
|
|||
|
|||
Excel calcalation
You need to change the format of the cell containing the total hours from a
format for a 24 hr clock to a format that can display cumulative hours past 24 (why it looks like it's subtracting after three days) - from Format, Cells, select a Time format that shows more than 24 hours, like 37:30:55 or enter a custom format of [h]:mm. "Dawiz" wrote: I am attempting to set up a spreadsheet to monitor time worked. I changed the cells for the time format, ie. 06:00. I need cells for the following, start time, end time, total time worked, hours over 8 hours, (for overtime). I have been able to get the time worked from the end time - start time. I also like to keep a cell for a running total of the time for the week. When I hit the 3rd day, it does not add anymore, in fact it subtracts a random figure from the total. The actual hours worked is correct. If anyone would like to see what I have, I can email it. Thanks |
Thread Tools | |
Display Modes | |
|
|