date help please

[Caro]

	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

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

[Caro]

=(c4,if(f4>"00:00"+1))
anybody ?

[bgoree09]

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]

Try

=C2+(D2>F2)