# Solved I am going in to my company at 9Am 1/1/13 and leaves 2Am 2/1

November 16, 2013 at 00:32:33
Specs: Windows 7
 I am going in to my company at 9Am 1/1/13 and leaves 2Am 2/1/13 next day. What formula should I use to calculate my worked hours in Microsoft excel?

See More: I am going in to my company at 9Am 1/1/13 and leaves 2Am 2/1

#1
November 16, 2013 at 12:57:28
 Since you have decided that Excel is the tool to use, I assume you know how to format the cells properly for your task.Entering "time 1" in [A1] and "time 2" in [A2], you should get the result by using the formula "=A2-A1".NigelWind slow

Report •

#2
November 16, 2013 at 16:40:46
 Nigel was close but no Cigar:Try this, with your Start Time in Cell A1 and your End Time in Cell A2:``` A 1) 09:00 2) 02:00 ```in cell A3, First format the cell as [H]:MMto Format the cell:On the RibbonSelect the HOME tabSelect FormatSelect Format Cells (at the bottom)Select Custom (at the bottom)Scroll down and select the [h]:mm formatClick OKNext, enter the formula: =A2+(A1>A2)-A1There are several other way to do this, one other is this formula: =MOD(A2-A1, 1) See how that works for you.MIKEhttp://www.skeptic.com/

Report •

#3
November 16, 2013 at 22:16:28
 Hi,This works good. Is it possible to know the answer for this question?. If an employee enters in to work at 2:00am 1/1/13 and leaves work at 4:00am 2/1/13. How do I calculate the time he worked for. I used your formula but it shows 2:00..Thanks

Report •

Related Solutions

#4
November 17, 2013 at 06:48:15
 Try this:=(A2+1)-A1What your doing is forcing Excel to see the second time as the next day by adding 1.For a very good explanation of how Excel handles Date & Time math see here:http://www.cpearson.com/excel/datea...MIKEmessage edited by mmcconaghy

Report •

#5
November 17, 2013 at 21:43:21
 Yes.. It works good.. Thank you..

Report •