Hi
I have tried to make a "simple"thing in excel. If i am at work 15 min more
one day, and 20 min less the other day, i want excel to count it. I can do it
(in hours an minutes) as long as it´s in +,but when it goes to minus, it
do'snt work. All i want i to do is to count, that yesterday i worked 2 hours
more an today 3 hours less, and it gives the result -1hour.

Excel treats date/time as number of days from 1/1/1900 and does not support
negative dates.

What you can do is enter actual time worked, add it up and compare with
total expected time... or you can do the maths in decimal and convert the
result to time as long as it is positive.

"lotte3108" wrote:

Hi
I have tried to make a "simple"thing in excel. If i am at work 15 min more
one day, and 20 min less the other day, i want excel to count it. I can do it
(in hours an minutes) as long as it´s in +,but when it goes to minus, it
do'snt work. All i want i to do is to count, that yesterday i worked 2 hours
more an today 3 hours less, and it gives the result -1hour.

"Sheeloo" wrote:

Excel treats date/time as number of days from 1/1/1900 and does not support
negative dates.

What you can do is enter actual time worked, add it up and compare with
total expected time... or you can do the maths in decimal and convert the
result to time as long as it is positive.

"lotte3108" wrote:

Hi
I have tried to make a "simple"thing in excel. If i am at work 15 min more
one day, and 20 min less the other day, i want excel to count it. I can do it
(in hours an minutes) as long as it´s in +,but when it goes to minus, it
do'snt work. All i want i to do is to count, that yesterday i worked 2 hours
more an today 3 hours less, and it gives the result -1hour.

Thanks for your answer. As i understand my wish is not possible, to use in
excel. My work time is very different over a 6 weeks period, so i thougth
that it would be easy to make it this way:'
1/3 +00:50
4/3 +00:15
6/3 -02:00
ialt - 0:55

As a workaround, you can have two columns...
In one enter time relative to, say, 8 hours. So if you work less by 15
minutes enter
7:45 and if more by 40 minutes then enter 8:45.
In the other column always enter 8:00
Then add those columns separately and subtract second from first if first is
greater or first from second if first is greater... hopefully you won't get
into the complication of more than 24 hours ...

"lotte3108" wrote:



"Sheeloo" wrote:

Excel treats date/time as number of days from 1/1/1900 and does not support
negative dates.

What you can do is enter actual time worked, add it up and compare with
total expected time... or you can do the maths in decimal and convert the
result to time as long as it is positive.

"lotte3108" wrote:

Hi
I have tried to make a "simple"thing in excel. If i am at work 15 min more
one day, and 20 min less the other day, i want excel to count it. I can do it
(in hours an minutes) as long as it´s in +,but when it goes to minus, it
do'snt work. All i want i to do is to count, that yesterday i worked 2 hours
more an today 3 hours less, and it gives the result -1hour.

Thanks for your answer. As i understand my wish is not possible, to use in
excel. My work time is very different over a 6 weeks period, so i thougth
that it would be easy to make it this way:'
1/3 +00:50
4/3 +00:15
6/3 -02:00
ialt - 0:55

"Sheeloo" wrote:

As a workaround, you can have two columns...
In one enter time relative to, say, 8 hours. So if you work less by 15
minutes enter
7:45 and if more by 40 minutes then enter 8:45.
In the other column always enter 8:00
Then add those columns separately and subtract second from first if first is
greater or first from second if first is greater... hopefully you won't get
into the complication of more than 24 hours ...

"lotte3108" wrote:



"Sheeloo" wrote:

Excel treats date/time as number of days from 1/1/1900 and does not support
negative dates.

What you can do is enter actual time worked, add it up and compare with
total expected time... or you can do the maths in decimal and convert the
result to time as long as it is positive.

"lotte3108" wrote:

Hi
I have tried to make a "simple"thing in excel. If i am at work 15 min more
one day, and 20 min less the other day, i want excel to count it. I can do it
(in hours an minutes) as long as it´s in +,but when it goes to minus, it
do'snt work. All i want i to do is to count, that yesterday i worked 2 hours
more an today 3 hours less, and it gives the result -1hour.

Thanks for your answer. As i understand my wish is not possible, to use in
excel. My work time is very different over a 6 weeks period, so i thougth
that it would be easy to make it this way:'
1/3 +00:50
4/3 +00:15
6/3 -02:00
ialt - 0:55
thanks again

I think this is one of the things where i must accept that paper, pencil
and headcounting, are the best.