Time calculations - help please

N

Nananana

Hi.
Novice user, please have mercy.

Using Excel 2003.

I have start/end working hours. Examples:
A1 = 08:27:00
A2 = 17:21:00

B1 = 08:40:00
B2 = 17:50:00

And the required hours per day (09:00:00). Let's assume it's A7.

1. How can I calculate the working hours per day (A2-A1, B2-B1 etc.) ?
Let's assume it's A3, B3, etc.

2. How can I calculate the extra hours, positive or negative number:
A3 - A7, B3 - B7 ?

Thanks and regards,
 
E

Earl Kiosterud

Nanana,

The worked hours would be =A2-A1. It may incorrectly format it, so you may have to set a
time format (Format - Cells - Number tab - Time).

The extra/short hours would be = = A2-A1-A7. Same deal on the formatting.
 
N

Nananana

Thanks.
Negative values are shown as #####.
How can I correct this, display "-00:25" for example?
Thanks and regards,
 
D

David Biddulph

Tools/ Options/ Calculation: select 1904 date system.
But beware of the effect if you try to copy dates to & fro between 1900 and
1904 systems.
 
N

Nananana

Great - thanks.

Tools/ Options/ Calculation: select 1904 date system.
But beware of the effect if you try to copy dates to & fro between 1900 and
1904 systems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top