Hi all
my colleagues have input timesheets onto excel but the time element has been input incorrectly - for example 7 hours and 15 minutes has been put on as 7.15 (ad there maybe should have been a colon in there as opposed to a decimal) - this should actually have been put on as 7.25 because when you multiply the charge rate by 7.15 we are losing 10 minutes of charge to the customer. Is there a way for excel to do a calculation so that even if the time has incorrectly been input as 7.15, the calculation can automatically convert this to a decimal time - i.e. 7.25?
Thoughts gratefuly appreciated