Excell question.

Jimbo · 1 Nov 2006 at 15:45

Hello all,

Im trying to do a simple spread sheet for my work hours. I want it to calculate my hours.

So I want to know how I can get a colum to count my hours? I mean if I put... 6:00 / 14:00 I want it to say 8 hours to the left auto, how do i do this?

welshtom · 1 Nov 2006 at 15:56

http://www.cpearson.com/excel/datearith.htm

This any good?

Looks to me like you can just use the sum function on them as they are recognised as times

Jimbo · 1 Nov 2006 at 16:10

Thanks mate, thats what i was after, cheers.

Mel_P · 1 Nov 2006 at 19:20

See PCW mag - latest edition - good example.

Mel