Elapsed time in seconds from separate date and time fields

[Guest]

Can I calculate elapsed time in seconds from four separate start date and
start time/end date and end time fields? I can do it no problem with two
fields - start date-time and end date-time fields but my client wants the
fields to be separate. Thanks for your help.

 

[Allen Browne]

Try something like this:
DateDiff("s", [StartDate] + [StartTime], [EndDate] + [EndTime])

That's considerably less efficient than using combined date/time fields, but
it should work.

 

[Guest]

Thanks so much. I'll try it.

Try something like this:
DateDiff("s", [StartDate] + [StartTime], [EndDate] + [EndTime])

That's considerably less efficient than using combined date/time fields, but
it should work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Can I calculate elapsed time in seconds from four separate start date and
start time/end date and end time fields? I can do it no problem with two
fields - start date-time and end date-time fields but my client wants the
fields to be separate. Thanks for your help.