Calculate negative hours (time)
<so I don't have the 1904 date system.
That system is present many versions of Excel, including yours
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Jolanta" wrote in message oups.com...
Hello
I only have excel 2000 - (SORRY, should have told you) so I don't have
the 1904 date system.
If I formate the cells as numbers excel shows the numbers instead of
the time values. So how can i keep
the right visualization?
Kind regards Jola
On 17 Sep, 11:36, Mike H wrote:
Hi,
Apart from the start and finis times I wouldn't work with the cells
formatted as time' i'd format them as numbers and this gets over the negative
time problem.
I.e. columns C, D & E formatted as number
A B C D E
Start Finish Hrs worked Required hrs +/1
08:00 16:00 =(B1-A1)*24 8 =D1-C1
Mike
"Jolanta" wrote:
Hi all
I have one employee NOT working 8 hours sometimes.
Monday 08:00 - 16:00 = 8 hours
Tuesday 08:00 - 15:00 = 7 hours
Wednesday 08:00 - 16:30 = 8,5 hours
a1 b1 c1 d1
08:00 16:00 b1-a1 = 8 +8
08:00 15:00 b1-a1 = 7 -1
08:00 16:30 b1-a1 = 8,5 +0.5
I cant figure out the d1 column formula. Any help appreciated. Sorry
if this has been asked before
Thanks in advance!
Jolanta- Dölj citerad text -
- Visa citerad text -
|