//some 3rd party need geo

Looking for an Excel Formula

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

Thank you very much

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

What is Google Allo? What is Google Duo? Google Allo UK release date rumours and features: Google…

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

These clever designs help visualise a complex intelligence tool

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…