New Member
June 1, 2023
Start Timestamp End Timestamp Actual Hours
4/9/2023 2:43 4/9/2023 6:35
4/5/2023 13:15 4/5/2023 13:38
4/9/2023 18:35 4/10/2023 6:35
4/9/2023 6:35 4/9/2023 7:38
3/24/2023 7:29 3/24/2023 18:35
3/24/2023 18:35 3/25/2023 6:35
3/25/2023 6:35 3/27/2023 18:35
3/25/2023 18:35 3/26/2023 6:35
3/26/2023 6:35 3/26/2023 18:35
3/26/2023 18:35 3/27/2023 6:35
Can I get help on how to get the actual hours from the start and end time stamp in a format as eg. 14.67 hrs or 2.5hrs, please
Trusted Members
Moderators
January 31, 2022
Perhaps the example in the attached file helps you on your way.
The formula itself is as simple as:
=B2-A2
That will result in a numer representing the duration in days. In the example it's 0.5. Thus half a day. Custom format the cell as [h]:mm (thus with square brackets surrounding the "h")
If you want the duration to be expressed in decimal hours you could use:
=(B2-A2)/24
1 Guest(s)