=(c4,if(f4>"00:00"+1))
anybody ?
This is my table above
Subject Start Date Start Time End Date End Time All Day Event Description Location 1098 21/07/2014 14:11 21/07/2014 19:51 FALSE 5h10 RD 22/07/2014 22/07/2014 16:05 TRUE RD 1128 23/07/2014 16:57 23/07/2014 00:29 FALSE 7h02 1116 24/07/2014 15:23 24/07/2014 00:43 FALSE 8h50
the end time is after midnight how do I add a day to the end date
Many thanks in advance
=(c4,if(f4>"00:00"+1))
anybody ?
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)
Bookmarks