Convert time format to a decimal

's Computer Specifications

I have a forumula that calculates total time. The results are shown in a
time format (66:30:00). How can we convert this to a decimal (66.5 hours)?
Thank you for your help.

Michele

's Computer Specifications

multiply by 24 and format it as general.

=a1*24
(and format that cell as general)

Michele wrote:
>
> I have a forumula that calculates total time. The results are shown in a
> time format (66:30:00). How can we convert this to a decimal (66.5 hours)?
> Thank you for your help.
>
> Michele

--

Dave Peterson

's Computer Specifications

Hi!

Multiply by 24:

=Your_Formula(.............)*24

Biff

"Michele" <(E-Mail Removed)> wrote in message
news:5D7F5711-3B62-468F-99BB-(E-Mail Removed)...
>I have a forumula that calculates total time. The results are shown in a
> time format (66:30:00). How can we convert this to a decimal (66.5
> hours)?
> Thank you for your help.
>
> Michele
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to convert time to decimal format	yolly	Microsoft Excel Worksheet Functions	4	14th May 2010 09:01 PM
convert time format to decimal format for excel?	Tim	Microsoft Access	1	7th Dec 2007 07:11 PM
How do I convert time (38:30) to decimal (38.5) format?	=?Utf-8?B?TG9yaQ==?=	Microsoft Excel Worksheet Functions	4	9th Nov 2005 05:00 AM
Convert decimal hour into time format?	=?Utf-8?B?cmFtZGFsZW4=?=	Microsoft Excel Misc	2	20th Jun 2005 06:21 PM
How to convert time to decimal format automatically...	alek23	Microsoft Excel Discussion	1	23rd Oct 2004 11:45 PM