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

Report •

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".


Wind slow

Report •

November 16, 2013 at 16:40:46
✔ Best Answer
Nigel was close but no Cigar:

Try this, with your Start Time in Cell A1 and your End Time in Cell A2:

1) 09:00
2) 02:00

in cell A3, First format the cell as [H]:MM
to Format the cell:
On the Ribbon
Select the HOME tab
Select Format
Select Format Cells (at the bottom)
Select Custom (at the bottom)
Scroll down and select the [h]:mm format
Click OK

Next, enter the formula: =A2+(A1>A2)-A1

There are several other way to do this, one other is this formula: =MOD(A2-A1, 1)

See how that works for you.


Report •

November 16, 2013 at 22:16:28
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..


Report •

Related Solutions

November 17, 2013 at 06:48:15
Try this:


What 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:


message edited by mmcconaghy

Report •

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

Report •

Ask Question