G
Giberish
How do I calculate time between two different dates? I am entering on a
form a date that includes two different time entries.... StartTime and
EndTime.
For example I want to calculate a time difference if I have an entry on
12/28/06 with a [StartTime] of 22:45 that has an [EndTime] on the the
next day at 00:45. How can I calculate the difference if I only have
time entries that are not based on dates? Is there a way to calculate
the difference if the expression assumes that 22:45 is for today and
anything later ([EndTime]) is after that time carrying over into the
next day?
form a date that includes two different time entries.... StartTime and
EndTime.
For example I want to calculate a time difference if I have an entry on
12/28/06 with a [StartTime] of 22:45 that has an [EndTime] on the the
next day at 00:45. How can I calculate the difference if I only have
time entries that are not based on dates? Is there a way to calculate
the difference if the expression assumes that 22:45 is for today and
anything later ([EndTime]) is after that time carrying over into the
next day?