R
Rockbear
In Out Hours
16:00 18:30 02:30
08:55 15:00 06:05
12:00 21:00 09:00
10:00 16:00 06:00
08:45 16:35 07:50
08:00 20:30 12:30
I have a hourlist like this, the hours are in format hh:mm, what I hope to
manage is..
lets call the columns
A B C D
IN OUT HOURS AFTER 18
in column D i want to have all hours after 18:00 listet automaticly, so if a
worker works to 19:30 the col. D should list 1:30
Is this possible with the HH:MM format??
16:00 18:30 02:30
08:55 15:00 06:05
12:00 21:00 09:00
10:00 16:00 06:00
08:45 16:35 07:50
08:00 20:30 12:30
I have a hourlist like this, the hours are in format hh:mm, what I hope to
manage is..
lets call the columns
A B C D
IN OUT HOURS AFTER 18
in column D i want to have all hours after 18:00 listet automaticly, so if a
worker works to 19:30 the col. D should list 1:30
Is this possible with the HH:MM format??