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?


--
tinytots
------------------------------------------------------------------------
tinytots's Profile: http://www.excelforum.com/member.php...o&userid=28906
View this thread: http://www.excelforum.com/showthread...hreadid=486539

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" wrote in
message ...

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?


--
tinytots
------------------------------------------------------------------------
tinytots's Profile:
http://www.excelforum.com/member.php...o&userid=28906
View this thread: http://www.excelforum.com/showthread...hreadid=486539

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


--
tinytots
------------------------------------------------------------------------
tinytots's Profile: http://www.excelforum.com/member.php...o&userid=28906
View this thread: http://www.excelforum.com/showthread...hreadid=486539