H
Hugh Stanley
I have a worksheet that I use time expressed in decimal notation,
ending with ".59" ...so time progresses in minutes from "1.59" (1:59
am) to "2:00" (2:00 am) ...it's in miltary time, so the pm
equivalent is "13.59" to "14.00".
I could use an elegant conversion formula that would take the "=now()"
equivalent and convert it to this decimal display. Any folks in the
loop on this one?
Thanks,
- Hugh -
ending with ".59" ...so time progresses in minutes from "1.59" (1:59
am) to "2:00" (2:00 am) ...it's in miltary time, so the pm
equivalent is "13.59" to "14.00".
I could use an elegant conversion formula that would take the "=now()"
equivalent and convert it to this decimal display. Any folks in the
loop on this one?
Thanks,
- Hugh -