Hi! I am stumped on this one, trying to figure out how to calculate total hours from a single cell that lists hours scheduled to work.
I know the simple solution is to split start time and end time into two different cells, however, that is not an option because I am trying to convert hours from an exported report that cannot be reconfigured at this time.
For example, I am looking for a formula that will return the total hours scheduled for C3:
C3 6:00A-2:00P
Any tips would be appreciated!
Bookmarks