Convert hours and minutes in time format into fractions of hours..

's Computer Specifications

I have created an electronic time sheet in Excel. I am trying to find out if
I can convert hours and minutes in time format into fractions of hours in
numerical format. Any ideas? Thanks!

's Computer Specifications

Let me see if I understood:

You have a cell with 1:30 PM, and you want to convert it to 1 1/2 ?

"Akern" wrote:

> I have created an electronic time sheet in Excel. I am trying to find out if
> I can convert hours and minutes in time format into fractions of hours in
> numerical format. Any ideas? Thanks!

's Computer Specifications

No. I have a cell with 7.30 in it, representing the difference between 4
times, morning in, lunch out, lunch in, evening out... The hours worked total
7 hours and 30 minutes in the format of 7.30. I need to convert it to 7.5 for
7 and 1/2 hours...

"Mexage" wrote:

> Let me see if I understood:
>
> You have a cell with 1:30 PM, and you want to convert it to 1 1/2 ?
>
>
> "Akern" wrote:
>
> > I have created an electronic time sheet in Excel. I am trying to find out if
> > I can convert hours and minutes in time format into fractions of hours in
> > numerical format. Any ideas? Thanks!

's Computer Specifications

On Mon, 18 Apr 2005 11:50:01 -0700, "Akern" <(E-Mail Removed)>
wrote:

>I have created an electronic time sheet in Excel. I am trying to find out if
>I can convert hours and minutes in time format into fractions of hours in
>numerical format. Any ideas? Thanks!

Excel stores time as fractions of a day. So just multiply by 24 and format as
numeric (or General).

--ron

's Computer Specifications

Ron! Thank you so very very much! I knew there had to be a mathematical
solution, but I didn't know how Excel was calculating the numerical value!
You are a life saver!!!

Thanks!
Amy

"Ron Rosenfeld" wrote:

> On Mon, 18 Apr 2005 11:50:01 -0700, "Akern" <(E-Mail Removed)>
> wrote:
>
> >I have created an electronic time sheet in Excel. I am trying to find out if
> >I can convert hours and minutes in time format into fractions of hours in
> >numerical format. Any ideas? Thanks!
>
> Excel stores time as fractions of a day. So just multiply by 24 and format as
> numeric (or General).
>
>
> --ron
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to convert Hours to Days, Hours Minutes	jamilla	General Software	1	21st May 2010 03:31 AM
Converting Hours in decimal format to Hours and minutes (short time)	Gina	Microsoft Access	2	26th Sep 2007 05:42 PM
convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.	=?Utf-8?B?aGFyZCB3b3JraW5nIGFuZHkgdw==?=	Microsoft Excel Worksheet Functions	6	9th Aug 2007 04:38 PM
HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES	=?Utf-8?B?RWNsYWlyZXM=?=	Microsoft Excel Worksheet Functions	2	9th Jul 2007 03:48 PM
Calculating elapsed time in hours:minutes (minus weekends [48 hours])	bigjess007	Microsoft Excel Worksheet Functions	2	20th Jul 2004 08:28 AM