| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Time Sheets (Yes, I've already done a search on previous posts)
I am trying to set up a kind of unique time sheet - I want it to have 3 in/out times, and a total number of HOURS worked per day. This is what I want it to look like: B C Time In: 8:00 AM Time Out: 12:00 PM Time In: 12:30 PM Time Out: 4:00 PM Time In: 5:30 PM Time Out: 7:00 PM Total hours: _____ Could someone help me with a formula, please?  -- LM813 ------------------------------------------------------------------------ LM813's Profile: http://www.excelforum.com/member.php...o&userid=30385 View this thread: http://www.excelforum.com/showthread...hreadid=500492 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Time Sheets (Yes, I've already done a search on previous posts)
total hours =(C2-C1)+(C4-C3)+(C6-C5)
OF COURSE you may have to adjust the format for time |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Time Sheets (Yes, I've already done a search on previous posts)
Hi,
Try this... =ABS(((A1-A2)*24)+((A3-A4)*24)+((A5-A6)*24)) Hope it helps! -- ERR229 "LM813" wrote: I am trying to set up a kind of unique time sheet - I want it to have 3 in/out times, and a total number of HOURS worked per day. This is what I want it to look like: B C Time In: 8:00 AM Time Out: 12:00 PM Time In: 12:30 PM Time Out: 4:00 PM Time In: 5:30 PM Time Out: 7:00 PM Total hours: _____ Could someone help me with a formula, please? -- LM813 ------------------------------------------------------------------------ LM813's Profile: http://www.excelforum.com/member.php...o&userid=30385 View this thread: http://www.excelforum.com/showthread...hreadid=500492 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Time Sheets (Yes, I've already done a search on previous posts
Of course make sure to use C not A in the cell references. Sorry!
-- ERR229 "ERR229" wrote: Hi, Try this... =ABS(((A1-A2)*24)+((A3-A4)*24)+((A5-A6)*24)) Hope it helps! -- ERR229 "LM813" wrote: I am trying to set up a kind of unique time sheet - I want it to have 3 in/out times, and a total number of HOURS worked per day. This is what I want it to look like: B C Time In: 8:00 AM Time Out: 12:00 PM Time In: 12:30 PM Time Out: 4:00 PM Time In: 5:30 PM Time Out: 7:00 PM Total hours: _____ Could someone help me with a formula, please? -- LM813 ------------------------------------------------------------------------ LM813's Profile: http://www.excelforum.com/member.php...o&userid=30385 View this thread: http://www.excelforum.com/showthread...hreadid=500492 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Time Sheets (Yes, I've already done a search on previous posts)
ERR229 Wrote: Hi, Try this... =ABS(((A1-A2)*24)+((A3-A4)*24)+((A5-A6)*24)) Hope it helps! -- ERR229 Yes, that does help! Thank you very much!! :) -- LM813 ------------------------------------------------------------------------ LM813's Profile: http://www.excelforum.com/member.php...o&userid=30385 View this thread: http://www.excelforum.com/showthread...hreadid=500492 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create formula to add 15 minutes to previous time value | Excel Worksheet Functions | |||
| time sheets | Excel Discussion (Misc queries) | |||
| CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME | Excel Discussion (Misc queries) | |||
| set or reset the print range for several sheets at a time? | Excel Discussion (Misc queries) | |||
| how to open and see 2 excel work sheets at a time | Excel Discussion (Misc queries) | |||
Linear Mode
