Time Conversion formula...

[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 -

 

[Jason Morin]

=TEXT(NOW(),"hh.mm")

HTH
Jason
Atlanta, GA