How shall i do a formula to make a time sheulde. (for my work hour.)
I have made cell 1 when i start the job , cell 2 when i stop the work and
cell 3 forpause/food time and cell 4 the sum hour my working day.
It work fine when i work on the ordnary day but when i work late or night
exel dont get right sum :-/
--
Henrik

Go to the following URL and scroll down the page until you find Time
functions. I think you'll find your solution he

http://www.cpearson.com/excel/datearith.htm
--
Kevin Backmann


"Henrik Björkner" wrote:

How shall i do a formula to make a time sheulde. (for my work hour.)
I have made cell 1 when i start the job , cell 2 when i stop the work and
cell 3 forpause/food time and cell 4 the sum hour my working day.
It work fine when i work on the ordnary day but when i work late or night
exel dont get right sum :-/
--
Henrik

Unless you give us an example showing how your data is entered and the
formula used, it is very difficult for anybody to give you an answer.
The more specific and clearer you are the more likely you are to get an
answer

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519512