LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 93
Default convert [h]:mm:ss to real number that I can use as a multiplier

I am setting up a spread sheet to use as a time sheet for my son. I have use
used the time format in to cells. Next I used the [h]:mm:ss to calculate the
elapsed time.

Ok, that seemed to work just fine. Now I would like to multiply the
elasped time returned by a dollar value in another cell. It appears that the
value returned by the [h]:mm:ss operator does not return a real number that
can be used to multiply by.

I'm sure that there is some conversion that I just missing. I would like
to know how to fix this problem.

Dean
 
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
Displaying date as a real number botany_girl Excel Discussion (Misc queries) 16 November 18th 08 04:06 AM
Convert real time to a % in Excel barry Excel Discussion (Misc queries) 1 August 1st 06 10:25 AM
real number kontraa Excel Discussion (Misc queries) 4 April 3rd 06 12:48 PM
Convert real number to an h:mm:ss display Tom Weyand Excel Worksheet Functions 2 February 22nd 06 10:30 PM
How do you convert numbers to real text Harry Excel Discussion (Misc queries) 5 January 27th 06 02:21 AM


All times are GMT +1. The time now is 12:02 PM.

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

About Us

"It's about Microsoft Excel"