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

Formatting Results of DateDiff Function

Status
Not open for further replies.
NewfieGolfer

NewfieGolfer

Technical User
Mar 29, 2001
80
CA
Hello All,

I'm using the DateDiff function to find the time difference between two dates. Right now I am getting the results in minutes. However, I would like to have the results formatted as follows,

Days: Hours: Minutes

So if the result (in minutes)is 1265, I would like it to be displayed as 0: 21: 5.

There is a twist. I'm also displaying a chart of the results. Right now, having the results in minutes works fine, the chart displays great. I'm worried that if I format the results, the chart will not display properly. Does anyone have advice on how to format the DateDiff result to something similar to above and still have it display appropriately in a chart as if it is in minutes?

Any help appreciated,
NG
 
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
500
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Help With Search Form Results 2
Replies
15
Views
657
caykamanj1966
caykamanj1966
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
502
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
290
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top