Emmersons_BrazillianDong
Well-known member
I need to create a basic table that shows costs but the supplier logs the time literally in hours and minutes - hh:mm
So 2.5 hours at £35 is easy but 2 hours and 17 minutes at £35 isn't.
How can I create a cell so that they can simply enter the hours:minutes and then it converts to a fraction of an hour so that I can multiply by the hourly cost?
So 2.5 hours at £35 is easy but 2 hours and 17 minutes at £35 isn't.
How can I create a cell so that they can simply enter the hours:minutes and then it converts to a fraction of an hour so that I can multiply by the hourly cost?