Hello
I am putting my work shift pattern into an Excel spreadsheet.
The shifts are represented like so:
RD = 0 (because its a rest day)
A = 13 hours
M1 = 8 hours
E = 5 hours
E2 = 6 hours
etc etc
What I am trying to do is make make excel is leave A, M1 or E etc in the
cell but recognise it as a figure then do a simple calculation/addition at
the end of each week to show me how many hours I have worked.
I hope I have explained myself OK and any advise/help will be appreciated.
Many thanks ... Mick
E-mail message checked by Spyware Doctor (5.5.0.212)
Database version: 5.09780e
http://www.pctools.com/uk/spyware-doctor/
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://freepctech.com/pcsoft.shtml
|