Windows 7 - Converting standard time to decimal time

Asked By sergi on 10-Aug-12 12:42 PM
Hi all,

I have a column of cells in [h]:mm format that I need to convert to decimal time. (e.g., A1 displays "196:30" (196 hours and 30 minutes) and I need to convert this to "196.5" (196.5 hours).

There is probably some dumb, obvious answer that I am overlooking, but if anyone can help, I'd appreciate it.


Claus Busch replied to sergi on 10-Aug-12 12:52 PM
Hi Sergio,

Am Fri, 10 Aug 2012 09:42:10 -0700 (PDT) schrieb

your time in A1, then
=A1*24  and format cell as general or number

Claus Busch
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
sergi replied to Claus Busch on 10-Aug-12 12:56 PM
Wow. That was embarrassingly obvious/simple. Thank you.