C# Programming
08-06-2009, 09:41 AM
I need a formula to calculate the difference in Hours and Minutes between two times.
Example: Table name = attandance and the fields that need to be calculated are:
[timein] = 1:15 PM
[timeout] = 1:44 PM.
I need the formula create a calculated field which equals 0:29.
I know the fomula that makes this work in Access (=HoursAndMinutes([Shipped]-[Picked]) but I need to write a Crystal report.
Thanks In Advance
Example: Table name = attandance and the fields that need to be calculated are:
[timein] = 1:15 PM
[timeout] = 1:44 PM.
I need the formula create a calculated field which equals 0:29.
I know the fomula that makes this work in Access (=HoursAndMinutes([Shipped]-[Picked]) but I need to write a Crystal report.
Thanks In Advance