B

#### BumblebeeFan

cannot seem to get the time format to show properly. Help?

Trying to subtract â€œlunch periodâ€ if partial day leave includes lunch

start/stop times â€“ the second row contains the formulas for all the cells.

(Iâ€™m sure thereâ€™s a much easier wayâ€¦ <smile>)

Cell E Cell F Cell G Cell H Cell I Cell J Cell R Cell S

Cell T

0730 1600 8.00 1200 1230 0.50 0900 1300 3.50

07:30 16:00 8.00 12:00 12:30 0.50 0900 1300 3.50

Formula

=IF(AND(R14="",S14=""),"",IF(AND(R14<=H14,S14>=I14),(((S14-R14)*24)-J14),IF(AND(R14>=H14,S14>=I14),((S14-R14)*24))))

Iâ€™d like the time format to show 3.30 instead of 3.50 and have the *24,

without it the answer is -0.33. Help, please?