Hi All!
Would like to seek help in counting the total hours based on the Time In and Out of an employee
Example
If cell A1 is time in = 10:00 AM
If cell B1 is time in = 07:00 PM
then I need a formula that will show a result of 09:00
Hi All!
Would like to seek help in counting the total hours based on the Time In and Out of an employee
Example
If cell A1 is time in = 10:00 AM
If cell B1 is time in = 07:00 PM
then I need a formula that will show a result of 09:00
Last edited by Locust; 10-17-2013 at 04:38 PM.
Isnt' B1 07:00 PM? if so use
=B1-A1
format as h:mm
Life's a spreadsheet, Excel!
Say thanks, Click *
Yeah, it should be 7:00 pm, my apologies for the typo.
But if the Start time is 10pm while the end time is at 7am?
Try this...If cell A1 is time in = 10:00 AM
If cell B1 is time in = 07:00 PM
=1-A1-B1
edit: wrap it in an IF statement...
=IF(B17<B16,1-B16+B17,B17-B16)
Last edited by FDibbins; 10-17-2013 at 05:19 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I think that this is what you are looking for:
A1=10:00 PM
B1= 7:00 AM
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
hi Locust. another alternative:
=MOD(B1-A1,1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks you guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks