Calculate Minutes Between Two Dates and Times

[robrich22]

Ok, I'v been using DateDiff to calculate hours between two times. Some of my records have different Start Dates/End Dates and I'd like to figure the total minutes between start date and end date time.

For Example..

Start Date: 01/01/2014
Start Time: 13:00

End Date: 01/02/2014
End Time: 13:00

I can use DateDiff("n", StartTime, EndTime) and it reports 0 because it doesn't account for the different dates. Is there a function to do this, or has anybody written one?

Thanks

[orange]

see if this helps http://www.youtube.com/watch?v=Z9FwFqGaphk

[June7]

Does that YouTube show concatenating the date and time parts? (I can't view it now.)

[robrich22]

I figured it out.. Here's the solution.

=DateDiff("n",[StartDate] & " " & [StartTime],[EndDate] & " " & [EndTime])