 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
This is so basic that I am ashamed. How do I convert hrs in time format to numbers to calculate billable time..
EG I have a time sheet that records start and finish times and then a cell that calcs the diff. But its time format and I want to turn 08:00 hrs into 8 so I can multiply it by my billable hrly rate.
Love and hugs in advance.
Depends how the 08:00 is stored, if it's a fixed length string you could use:
=val(left(cell,2)) + val(right(cell,2)/60)
its ok sussed it thanks. Just multiply by 24 in number format.. Happy days.
or the function Hour(Cell)
The only thing to bear in mind is that depending on which format you have, you might get an oddity in how periods longer than one day are displayed - e.g. if your start time is 08:00 01/01/2012 and finish time is 20:00 03/01/2012 then the difference in hh:mm format will be 12:00 even though the underlying number that Excel has stored is 2.5. If you're multiplying by 24 the total hours will be correct though, just make sure you don't show the wrong figure to a client and confuse them!
Good tips, thanks people. Virtual love and hugs.