I have a list view where i capture employee's Time' In and Time Out at end of there shift. Both of those controls are of type Time. Once Values are Set, i would like to get time diffrence between timein and timeout. How can i do that, results needs to be stored in Time format?
Thank You
Did you look at the available Date and Time expression operators? There's a "Date/Time Difference" function that would meet your need.
| Date/Time Difference | Determines the difference between two dates, returning the difference in the specified interval with sub-intervals as decimal fractions. Intervals available: year, month, day, hour, minute, second and millisecond | Interval: Day First Date: 01/01/2009 00:00:00 AM Second Date: 01/02/2010 00:00:00 AM Result: -366 |
What is Interval on this case, what should by entry be, since i am looking to get Time returned?
Whatever you want... Your choices for time are hours, minutes, seconds and milliseconds.
Thanks that worked.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.