[Solved] Working Hours (over 24 per week)

[Morgaine]

timesheet.ods

(15.73 KiB) Downloaded 123 times

I am having trouble with my timesheet.

Attached is the offending article. As you can see the first week I recorded the spreadsheet worked fine and it recorded the 30 hours worked.

I copied and pasted the first week and now when I look at the totals I can't get them to go over 24 hours. I have tried [hh]:mm but that didn't work. I'm baffled as to why this worked fine the first time but not on the copy.

[thinman3]

Have sent a PM to Morgaine that nothing got uploaded to the forums.

thinman3

[Villeroy]

Number format [HH]:MM (with brackets) might solve this.

[fst]

Hi,

the problem is in cells F65 and F96.

If you want to get a difference over two days, you have to enter the times with the date information:

D96: 14.04.2013 23:15:00 (for April 14, 2013 23:15h)
E96: 15.04.2013 0:10 (for April 15, 2013 00:10h)

You might check the other data in D7:E51 as well.

Frank

[acknak]

The usual way to handle this (finding elapsed time where start/end may span midnight) is to replace a simple end-start with: end-start+(end<start)

So instead of =E65-D65, you use =E65-D65+(D65>E65)

It looks like there are also some bad entries. For example, F25 records a visit of >24 hours.