time computation

[radix]

I'm just want to get information on how i can get the total number of hours if the date is different. example : person A is working on a graveyard shift and i want to get how many hours and mins he worked by entering his login and logout time. his shift would start at 8PM and would end at 4AM. i tried subtracting the logout time to the login time but i only get sharp sign to the cell. please help. thanks

 

[Brian from Maui]

I'm just want to get information on how i can get the total number of hours if the date is different. example : person A is working on a graveyard shift and i want to get how many hours and mins he worked by entering his login and logout time. his shift would start at 8PM and would end at 4AM. i tried subtracting the logout time to the login time but i only get sharp sign to the cell. please help. thanks

Try something like,

=B1-A1+(B1 < A1)

Where A1 is start time and B1 is end time

BTW..

8PM is not a valid time but 8:00 PM is.

 

[radix]

W0W! super... thank you very much. this will be a great help.

 

[radix]

By the way, i have another dilemma. what kind of formula should i use in case lunch and breaks would need to be taken off this computed time. i tried using the IF formula but i did not arrive to the right solution. thanks in advance

 

[Brian from Maui]

By the way, i have another dilemma. what kind of formula should i use in case lunch and breaks would need to be taken off this computed time. i tried using the IF formula but i did not arrive to the right solution. thanks in advance

See,

http://www.cpearson.com/excel/overtime.htm