Excel compute time

110 pts.
Tags:
Microsoft Excel
We have an Excel spreadsheet that volunteers use to document their time working. The time in an out is based on 12-hour time (am/pm). I would like a formula that would use the in and out time to compute number of hours worked. Anyone know how to do this?
ASKED: February 15, 2008  12:51 AM
UPDATED: February 2, 2011  3:07 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I believe that this formula will give you want you are looking for.

<pre>=HOUR(SUM(B1-A1)) & “:” & MINUTE(SUM(B1-A1))</pre>

This function assumes that A1 is the starting time, and that B1 is the Ending Time. You do need to make sure that Excel understands that the columns A and B are setup in the time format, and don’t have just text in there. If you need to handle overnight shifts this will need to be adjusted, but if everything is single day work without going over midnight it’ll work just fine.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • XMac
    Thank you so much, Mrdenny! The formula works perfectly!
    110 pointsBadges:
    report
  • Nilouch
    Thank you for the excel formula... it works perfectly...
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following