Looking for an Excel Formula

  wee eddie 20:47 20 May 2008
Locked

to turn Hours expressed as 08:45:00 (Hours:Minutes:Seconds) to an Hours & Decimal of an Hour. So that I can calculate the Total Pay for the period.

I've used Excel's Help which recommends the INT Function but that does not achieve the result I hoped for. I probably got the formula wrong.

  Rigga 08:00 21 May 2008

try

=HOUR(A1)+(MINUTE(A1)/60)+(SECOND(A1)/3600)

Where the time is in cell A1

Make sure the target cell for the hours as decimal, is formatted as either General or Number.

HTH. R.

  wee eddie 11:09 21 May 2008

Thank you very much

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Acer Predator 21X review

These hilarious robot GIFs will be sure to make you smile

Best podcast apps for iPhone & iPad

Nokia 8 : design, caractéristiques techniques, date de sortie