Converting standard time to decimal time

  • Thread starter Thread starter sergio
  • Start date Start date
S

sergio

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'm overlooking, but if anyone can help, I'd appreciate it.

Thanks.
 
Hi Sergio,

Am Fri, 10 Aug 2012 09:42:10 -0700 (PDT) schrieb
(e-mail address removed):
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).
Click to expand...

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


Regards
Claus Busch
 
Wow. That was embarrassingly obvious/simple. Thank you.

Hi Sergio,



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

Sergio Hernandez:


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).
Click to expand...



your time in A1, then

=A1*24 and format cell as general or number





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
Click to expand...
 
Back
Top