| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
New Time Card
HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOWS THE EXACT TIME THE PERSON WORKED The Cell is information is b2 the hours and c2 the hr the shift ends and on d2 woul take out the 1/2 hour for lunch and it would it give you then the hours worked for the day Thankyou for your help the formula below maybe wrong so any help would be greatly appreciated =TIME(b1/100,MOD(b2,100),0) gives 2:11 PM when A1 has value 1411 -- OSSIE ------------------------------------------------------------------------ OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638 View this thread: http://www.excelforum.com/showthread...hreadid=524580 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
New Time Card
See this:
http://www.excelforum.com/showthread...hreadid=523774 Biff "OSSIE" wrote in message ... HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOWS THE EXACT TIME THE PERSON WORKED The Cell is information is b2 the hours and c2 the hr the shift ends and on d2 woul take out the 1/2 hour for lunch and it would it give you then the hours worked for the day Thankyou for your help the formula below maybe wrong so any help would be greatly appreciated =TIME(b1/100,MOD(b2,100),0) gives 2:11 PM when A1 has value 1411 -- OSSIE ------------------------------------------------------------------------ OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638 View this thread: http://www.excelforum.com/showthread...hreadid=524580 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
New Time Card
what i need to know its how many hours the person worked i mean like if they came in 6 am the ens shift its 2:30 pm and the next cell would have the answer as 8 hrs or for my night shift they come in at 14:00 and dont leave till 10:30 taht woudl give me again the 8 hrs or whaterver hours they work hope i explain better thanks -- OSSIE ------------------------------------------------------------------------ OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638 View this thread: http://www.excelforum.com/showthread...hreadid=524580 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
New Time Card
Hi!
Try this: A1 = 6:00 AM B1 = 2:30 PM =IF(COUNT(A1:B1)<2,"",B1-A1+(B1<A1)-TIME(0,30,0)) Subtracts 30 minutes for lunch, break, whatever. Biff "OSSIE" wrote in message ... what i need to know its how many hours the person worked i mean like if they came in 6 am the ens shift its 2:30 pm and the next cell would have the answer as 8 hrs or for my night shift they come in at 14:00 and dont leave till 10:30 taht woudl give me again the 8 hrs or whaterver hours they work hope i explain better thanks -- OSSIE ------------------------------------------------------------------------ OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638 View this thread: http://www.excelforum.com/showthread...hreadid=524580 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Card | Excel Discussion (Misc queries) | |||
| Time card template | Excel Worksheet Functions | |||
| Formula for a time card | Excel Worksheet Functions | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| How do I set up a time card format in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
