Hi tppcsjv,
That is correct - although especially if you want to enter times that go across midnight (which you do from what you say below).Originally Posted by tppcsjv
Time worked will simply be TimeOut-TimeIn. Other calcs, such as over time etc will obviously depend on your terms, but might perhaps only kick in where someone has worked more than 50 hours a week (say)?All I want to do is put in a formula that, after I enter the time in and time out, will calculate for me the total hours worked and allocate time and a half and double time for me. We have a column for time in, another for time out, one for regular time, one for over time, one for double time, one for paid time off and each paid week has a total at the bottom.
That shouldn't matter if you enter the date / time in all cases. It will still be TimeOut - TimeIn. For example:We also have staff that start work at 11pm one day and get off of work at 7am the next morning. Please help. Thanx in advance.
TimeIn = 23:00 hrs on 11 Nov 2005 (= 38667.958333... as a date / time value)
TimeOut = 07:00 hrs on 12 Nov 2005 (= 38668.291666... as a date / time value)
TimeOut - TimeIn = 8 hours (= 0.333... as a date / time value being 1/3 of a day)
HTH,
Alan.
To help us help you, try to do the following:
1) Be precise about what you want to do, and provide a sample of your data / inputs - exactly as they are.
2) State the formula(e) / code that you have tried. People are happy to help , but if you haven't even given it a go, you are less likely to get help, or the help you get will be very basic.
3) State the results you are getting from your formula(e) / code already.
4) State the outputs that you *want* to be getting.
How do l put times into formula and add up the hours and time be the pay rate
IN OUT IN OUT REG HRS
4/14/06 6:00 PM 4/14/06 10:00 PM 4/14/06 11:00 PM 4/15/06 3:00 AM 8
REG HOURS FORMULA =SUM((B2-A2)*24,(D2-C2)*24) RIGHT CLICK FORMAT NUMBER
Last edited by rodyzamora; 04-13-2006 at 06:58 AM.
IN OUT IN OUT REG HRS
4/14/06 6:00 PM 4/14/06 10:00 PM 4/14/06 11:00 PM 4/15/06 3:00 AM 8
FORMULA =SUM((B2-A2)*24,(D2-C2)*24) THEN RIGHT CLICK FORMAT TO NUMBER
What if they only have the start time and stop time and the time for lunch
ie.
Time In Time Out Lunch
7:30 AM 5:00 PM :30
How would you calculate hours worked minus Lunch? The result I am looking for is 9:00
Thanks
Your lunch would have to be a recognisable time in excel, probably 0:30 then you just use
=B2-A2-C2
format result cell as h:mm
where A2 contains start time, B2 end time and C2 lunch
If your shift might cross midnight, e.g. 11:00 PM to 07:00 AM change to
=MOD(B2-A2,1)-C2
Please anyone could you guys help me on how to Convert decimal value to time value, tq
Try this,
=A1/(60*24) then format to Time
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
If you mean a decimal value in hours, e.g. to convert 8.6 to 8:36 just divide by 24, e.g.
=A1/24
format as [h]:mm
ok let say i have 150 minutes, how can i convert it to Hours and minutes format to be 2 hours and 30 minutes format and not 2.5 if i devide it to 60
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks