Calculate negative hours (time)
Hi Jolanta,
Use the 1904 date system. Do read HELP first so you know what the effects are.
ToolsOptionsCalculation tab, check "1904 date system"
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Jolanta" wrote in message oups.com...
| 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
|
|