Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Time recognized as a whole number?

I want to use a time value presented in hours and minutes as a number that
can be used to multiply to get a value. ie. so many hours and minutes
equals a number and using that number times a dollars per hour number to get
a gross.


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,345
Default Time recognized as a whole number?

Did you suddenly change your clock?

See previous post.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Bob Morrison" wrote in message
...
I want to use a time value presented in hours and minutes as a number that
can be used to multiply to get a value. ie. so many hours and minutes
equals a number and using that number times a dollars per hour number to
get a gross.




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
date not recognized The Stumper Excel Discussion (Misc queries) 8 May 22nd 07 02:57 PM
Blank Value not recognized? Laura Excel Worksheet Functions 3 January 24th 07 12:14 AM
All columns not being recognized in .csv file. Decision Assist Excel Discussion (Misc queries) 3 October 17th 06 07:59 PM
Command not recognized WLMPilot Excel Worksheet Functions 2 April 29th 05 04:08 PM
Data isn't being recognized. ConfusedDataMonkey Excel Worksheet Functions 1 January 20th 05 04:41 PM


All times are GMT +1. The time now is 01:14 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"