calculating fees from hours and minutes

[tinytots]

I have a spreadsheet that calculates total hours of attendance but I
then want to calculate fees.
e.g 67 hours 50 minutes x £3.00 an hour = ?
Do I need to convert the hours and minutes into a decimal if so how do
I do it?

 

[Bob Phillips]

Just multiply the hours and minutes by 24, as time is held as a fraction of
a day.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[tinytots]

Thanks. Works perfectly.Its easy when you know how.