time task

[Guest]

hi community

any help much appreciated for this time task...

D E F
G
4 Shift Start Time
Dismiss Time
5 1 08:30
18:15
6 2 09:30
19:15
7 3 10:30
20:15
8 Shift Sign In Sign Out OT
(in minutes)
9 08:30 18:45
10 09:00 18:57:38
11 10:01 20:16

referring to the above scenario, how can can set the Shift in cell (OT in
minutes) -G9 - G11, where I want to set the criteria as:

how can i find the difference between the "Dismiss Time" in Col G and the
"Sign Out" time in Col F and the difference must be not less than or equal 30
minutes if it is less than 30 minutes, i wish to display a value of "0" (in
column G9 - G11, it should be formatted in minutes)

thanks community for the help

 

[Guest]

Perhaps you mean something like this sample set-up:
http://www.flypicture.com/download/NTYwMA==
time task.xls

where you could then place in G9:
=IF((F9-F5)<TIME(0,30,0),0,F9-F5)
and copy G9 down to G11 to return the OT values

Adapt to suit your actual set-up ..