Time calculations - help please

  • Thread starter Thread starter Nananana
  • Start date Start date
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,
 
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.
 
Thanks.
Negative values are shown as #####.
How can I correct this, display "-00:25" for example?
Thanks and regards,
 
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.
 
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.
Click to expand...
 
Back
Top