Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Business Tech Help

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Looking for an Excel Formula

wee eddie

Likes # 0

Posted May 20, 2008 at 8:47PM

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.

Like this post
Rigga

Likes # 0

Posted May 21, 2008 at 8:00AM

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.

Like this post
wee eddie

Likes # 0

Posted May 21, 2008 at 11:09AM

Thank you very much

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.