date help please

Caro

New member
Joined
Mar 1, 2014
Messages
12
Reaction score
0
Points
0
SubjectStart DateStart TimeEnd DateEnd TimeAll Day EventDescriptionLocation
109821/07/201414:1121/07/201419:51FALSE5h10
RD22/07/201422/07/201416:05TRUERD
112823/07/201416:5723/07/201400:29FALSE7h02
111624/07/201415:2324/07/201400:43FALSE8h50
This is my table above
the end time is after midnight how do I add a day to the end date

Many thanks in advance
 
Good morning,

One note, on your times that are after midnight the dates should be increased. Currently the end times are before the start times. To figure hours worked use:

= ( (End Date + End Time) - (Start Date + Start Time) ) * 24

Hope this helps,
 
Try

=C2+(D2>F2)
 
Back
Top