P
Peter_g
Hello,
I was hoping someone could share their expertise with me. I've made a
excel sheet for producing a staff roster that automatically calculate
employees wages in advance. The problem is in order to keep all th
formulaes working correctly, time must be expressed as a decimal numbe
(e.g half nine in the morning would be 9.5). I am a bit of
perfectionist so I find this somewhat annoying. Can someone suggest
way to format the cell such that 9.5 would appear as 09:30 yet continu
to effectively be 9.5 for the sake of the formulaes?
Thank you all very muc
I was hoping someone could share their expertise with me. I've made a
excel sheet for producing a staff roster that automatically calculate
employees wages in advance. The problem is in order to keep all th
formulaes working correctly, time must be expressed as a decimal numbe
(e.g half nine in the morning would be 9.5). I am a bit of
perfectionist so I find this somewhat annoying. Can someone suggest
way to format the cell such that 9.5 would appear as 09:30 yet continu
to effectively be 9.5 for the sake of the formulaes?
Thank you all very muc