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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert an integer into minutes

Status
Not open for further replies.
sbbrown9924

sbbrown9924

Technical User
Mar 7, 2003
80
US
How would I convert an integer value into minutes so it could be formatted using FormatDateTime(var,4)?
 
Sort by date Sort by votes
A starting point:
FormatDateTime([number of minutes]/1440, 4)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
PHV;

Thanks - that worked great. Are you dividing by 1440 to make the [number of minutes] a percentage of the total minutes in a day?
 
Upvote 0 Downvote
1440 = 24 * 60, ie the number of minutes in a day.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
4K
dhookom
dhookom
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
239
OzFoxy
OzFoxy
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
598
dhookom
dhookom
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
766
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top