UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Time Thats Been Stored As Text Convert To Number, Access 2016    
 
   
wornout
post Jul 8 2017, 04:45 AM
Post#1



Posts: 972
Joined: 17-November 13
From: Orewa New Zealand


I have a time thats been stored as text 9:30 or sometimes it could be 9:00
can I convert that in a query to number so I can add cost to it? or add them up ?

when i say time they are hours
Go to the top of the page
 
Jeff B.
post Jul 8 2017, 06:21 AM
Post#2


UtterAccess VIP
Posts: 9,885
Joined: 30-April 10
From: Pacific NorthWet


So, you're saying "9:30" means 9 hours and thirty minutes?

P.S. what do you get if you "add cost" to # of hours?

--------------------
Regards

Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
 
GroverParkGeorge
post Jul 8 2017, 10:26 AM
Post#3


UA Admin
Posts: 31,245
Joined: 20-June 02
From: Newcastle, WA


Excuse me while I drag my soapbox over to this question.....

Okay, we have (at least) two, rather ambiguous, ways of referring to time. "Elapsed" time and "Clock" time.

When we use the bare word, "time", therefore, we're inviting ambiguity into the discussion. As Jeff has already pointed out, we assume, but do not know, that you actually mean "elapsed time" here, not "clock time". If that's the case, then one approach will resolve the problem for you, but if you actually mean "clock time", then a whole different approach is called for.

I like to point out that ambiguity is fine--and even necessary--in the pursuit of humor, poetry and politics. However, in discussions of databases, ambiguity is bad juju.

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 12:15 AM