Looking for an Excel Formula

  wee eddie 20:47 PM 20 May 08
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 AM 21 May 08

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 AM 21 May 08

Thank you very much

Advertisement

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

14 best budget laptops of 2015: best budget laptops reviews - best cheap laptops - best bargain…

1995-2015: How technology has changed the world in 20 years

Animated film of Raymond Briggs' Ethel and Ernest ramps up production

From Antennagate to Yellowgate: The 10 worst Apple scandals (and why they were blown out of proport)…