change to days, hours, minutes

[jjb373]

This displays the hours and mintues like this:
51hr 05min

=[txtAvgHXS]\3600 & "hr " & Format(([txtAvgHXS]-([txtAvgHXS]\3600)*3600)\60,"00" & "min")

I want to display:
2d 3hr 05min

Any suggestions?

Thanks in advance

 

[snyperx3]

assuming txtAvgHXS is in seconds,
txtAvgHXS\86400
will give you days.

=[txtAvgHXS]\86400 & "d " & [txtAvgHXS]\3600 & "hr " & Format(([txtAvgHXS]-([txtAvgHXS]\3600)*3600)\60,"00" & "min")



-Pete

 

[MichaelRed]

There are numerous threads addressing date/time calculations and display formats in these fora. Use of the search funcfion with some key words of choice should return a sample of the possabilities as well as providing some insight into how to retrieve information more efficiently.




MichaelRed

 

[mssbass]

So, can you redo to assume txtAvgHXS is in minutes?

 

[snyperx3]

Sure.

=[txtAvgHXS]\1440 & "d " & [txtAvgHXS]\60 & "hr " & Format(([txtAvgHXS]-([txtAvgHXS]\1440)),"00") & "min"

-Pete

 

[dhookom]

Consider using Doug Steele's function from

http://www.accessmvp.com/djsteele/Diff2Dates.html.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]