Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Akern
 
Posts: n/a
Default Convert hours and minutes in time format into fractions of hours..

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!
  #2   Report Post  
Mexage
 
Posts: n/a
Default

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!

  #3   Report Post  
Akern
 
Posts: n/a
Default

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!

  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Mon, 18 Apr 2005 11:50:01 -0700, "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!


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


--ron
  #5   Report Post  
Akern
 
Posts: n/a
Default

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"
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I convert fractional hours to minutes? Speck Teck Excel Discussion (Misc queries) 3 March 4th 05 01:18 AM
Time - Hours and Minutes Mark Zak Excel Discussion (Misc queries) 4 February 18th 05 02:51 AM
convert hours and minutes to minutes idaho Excel Discussion (Misc queries) 2 January 27th 05 10:45 PM
How do I convert Military Time to minutes? Rachael Excel Worksheet Functions 1 January 6th 05 11:01 PM
How do I convert times from hours to minutes? kkrebs Excel Discussion (Misc queries) 5 December 30th 04 07:13 PM


All times are GMT +1. The time now is 11:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"