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 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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Wow. That was embarrassingly obvious/simple. Thank you.

On Friday, August 10, 2012 12:52:19 PM UTC-4, Claus Busch wrote:
> 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