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?