ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Time recognized as a whole number? (https://www.excelbanter.com/new-users-excel/150782-time-recognized-whole-number.html)

Bob Morrison

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.



Sandy Mann

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.






All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com