Question

Locked

Excel help

By paul.gray9 ·
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)

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

More information needed....

by ThumbsUp2 In reply to Excel help

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?

Collapse -

Re: Excel

by paul.gray9 In reply to More information needed.. ...

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

Collapse -

You are going to need....

by ThumbsUp2 In reply to Re: Excel

... 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.

Collapse -

Excel/time calculation and shift work

by Peconet Tietokoneet In reply to Excel help

http://en.allexperts.com/q/Excel-1059/time-calculation-shift-work-1.htm

Easy Date and Time Entry in Excel
http://www.pcmag.com/article2/0,2817,2316759,00.asp

Use Excel to calculate the hours worked for any shift
http://articles.techrepublic.com.com/5100-10878_11-5756139.html

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums