How to make this work????

[jrad]

Hello. I use excel to make my schedules for work and I would like to b
able to type in a shift like 9~6 and have it equal an 8 hour shift s
it adds up in the totals column by itself. but I don't want 8 t
actually appear in the cell.???????????

 

[Cesar Zapata]

if I understand you what you saying then is not possible unless without
a ugly hack otherwise check Chip's solution to get some ideas.


http://www.cpearson.com/excel/overtime.htm

hope it helps.

Cesar Zapata