Converting standard time to decimal time

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

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top