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    
post Jul 8 2017, 04:45 AM

Posts: 1,025
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

UtterAccess VIP
Posts: 9,950
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?


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
post Jul 8 2017, 10:26 AM

UA Admin
Posts: 32,130
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    22nd March 2018 - 10:54 AM