Hi guys,
Currently using google sheets and I am not sure how to convert the time duration of 5:30 hours (see below) into a number so I can work out an hourly rate - without having to manually enter into the formula i.e =1000/5.5 each time.
Time Start 19:00
Time End 00:30
Duration (hr) 05:30
I am sure there is a simple solution but have not been able to find it!
Any assistance would be much appreciated.
Cheers
Bookmarks