Software

Ask something
Question Locked

Excel help

0 helpful
5 replies

by paul.gray9

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My wife is a nurse and i want to do an off duty form in excel, but as this needs to be printed with shift data i.e: E = Early L = late, O = Off e.t.c, but i want the total column at the end to be numeric for the hours worked (8 hour shifts)

5 replies

by thumbsup2

I'm not sure what you're trying to end up with. Are you wanting to show her how many times (when) she has gone in early, stayed late or worked her day off? In other words, do you want to be able to input the time she went in and the time she came home and compare that to her actual work schedule, then produce a report to show her how much of her own time she's actually spending at work?

Can the column with the E/L/O be off to the side so that it's not part of a total column, yet a formula could be used to show those letters based on her normal work schedule compared to the actual worked hours?

by paul.gray9

Hi thaks for the reply. I only want the cells to only show either an E,L,O,P/D,H which all equate to 8 or 12 hour shifts and only one column at the end of the month showing the total hours worked i:e
E,L,E,E,O,L,O = 40 HOURS or 60 for a 12 hour day, all i want to print is the letters not the numeric total as the nurses only need to know there shift pattern for the month, hope that helps, i can choose to leave the total column out when printing,

Cheers

by thumbsup2

... to input the numbers somewhere. You could put them off to the right, out of the print view. You could even put them on another sheet. But, you need to input the numbers somewhere and then either create a lookup table for the value of the letters or create one huge IF formula to display the letters based on values elsewhere. Likewise, your total hours per week (40 hours, etc...) will have to reference those numbers.

You can't add/subtract letters, but you can add/subtract the values they represent based on numbers which are stored elsewhere.

This discussion is closed to new replies.