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

Do you think Amazon has bigger plans for Whole Foods?

Discuss in The Lounge

Poll History