Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
turning a string of cells into a work shift (eg. 9am-7pm)
how can i turn a string of values from one sheet into a work shift on a
second sheet? for example: C27 is the 10am to 11am hour, D27 is the 11am to 12pm hour, and so on; if the whole hour is worked, a 1 is typed in that cell, if the off time is 12:30, then .5 is typed in that corresponding cell, and so forth for quarter hour incriments. so if a person worked from 10am to 11:30 am then the sequence would be: [1][.5] with zeros for all other corresponding hour blocks. what i want to do is have a second sheet say 10am-11:30am or whatever string of 1's, .75's, .5's, and .25's that are typed into the hour block cells. any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a work shift schedule | Excel Discussion (Misc queries) | |||
control shift highlighting does not work | Setting up and Configuration of Excel | |||
Ctrl-Shift-Arrow combination does not work | Excel Discussion (Misc queries) | |||
monthly one shift work schedule | New Users to Excel | |||
CTRL+Shift+Arrow Doesn't Work | Excel Discussion (Misc queries) |