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
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
