Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

time calculations

Status
Not open for further replies.
shelspa

shelspa

Technical User
Dec 13, 2001
66
US
I want to convert a short time field into straight number of minutes to do some calculations. Example make 1:10 equal 70 (minutes). I have searched to no avail and I realize this could be a can of worms. Ideas?
 
Sort by date Sort by votes
or since there are 1440 minutes in a day:
x = [MyTimeField] * 1440

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
319
OzFoxy
OzFoxy
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
804
dhookom
dhookom
WimDC
  • Locked
  • Question
Help on grouping by TIME Range
Replies
1
Views
368
dhookom
dhookom
ptrifile
  • Locked
  • Question
Change Date/Time Field 1
Replies
5
Views
296
ptrifile
ptrifile
soloracer
  • Locked
  • Question
Run-time error 3075 in QDF 2
Replies
7
Views
471
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top