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
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
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,
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Try

=C2+(D2>F2)
 
Top