Converting standard time to decimal time

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

 

[Claus Busch]

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).

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


Regards
Claus Busch

 

[sergio]

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).

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