Excel calcalation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dawiz - 06 Apr 2007 05:22 GMT

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

Reply to this Message

BoniM - 06 Apr 2007 06:00 GMT

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.

> 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,
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message