Good Morning/Afternoon,
Can anyone help with how to calculate total time worked? We get data from our case management system and need to determine how much actual time worked. The hours show like this:
Start End
User 1: 7:00 AM 10:00 AM
User 1: 8:00 AM 11:00 AM
User 1 8:00 AM 2:00 PM
User 1: 10:00 AM 4:00 PM
The user will post notes as they work with consumers. What I need is not total time (17 hrs) but actual time 9 hrs (7:00AM - 4:00 PM). Been racking my brain but cant figure this one out. Any help would be awesome.
Bookmarks