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?

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

Nigel

Wind slow

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:00in 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 OKNext, 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.

MIKE

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

Try this: =(A2+1)-A1

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:

http://www.cpearson.com/excel/datea...

MIKE

message edited by mmcconaghy

Yes.. It works good.. Thank you..

Ask Your Question

Weekly Poll

Would you be willing to go on a SpaceX trip around the moon?

Discuss in The Lounge

Poll History