wMy timesheet looks like this:

inn out inn out reg,h 50% 100% Total
D13 E13 F13 G13 H13 I13 J13 K13

06:00 12:00 13:00 16:00 7,5 ??? 0,0 ???
(1,5) (9,0)


I need help with I13: The hours between 7,5h and 10,5h.

H13 to be between 0,0 to 7,5 (this one works!)

=HVIS((((E13-D13)+(G13-F13))*24)7,5;7,5;((E13-D13)+(G13-F13))*24)

I13 to be between 0,0 to 3,0 (this is the hours after H13 (7,5), not
working?)

=HVIS????

J13 to be between 0,0 to 13,5 (this is the hours after H13 and I13
(10,5), this is working!)

=HVIS(((E13-D13)+(G13-F13))*2410,5;((E13-D13)+(G13-F13))*24-10,5;0)



NB! I think the HVIS comand is the same as IF, logic test.

Harald
Systemgulv