Question Locked

How do I change time Hr : Min to a decimal in an excel cell

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I can not change hr:min in an excel cell to a decimal 18:30 to 18.5. I am also looking for
if C4=<6 then C5 is C4-.5
These two problems fix would make me a very happy camper.

1 reply

This discussion is closed to new replies.