access time conversion problem (1 Viewer)

[shailesh_gothal]

i am creating a report for the meeting time the total should show the total days, hours and minits

if i will get total as 36.10 min then it should show 1 day 12 hours and 10 min

 

[llkhoutx]

Build yourself a function that converts minutes to days, hours, minutes.

 

[Pat Hartman]

These two articles will get you started:

Q130514 - ACC Storing, Calculating, and Comparing Date-Time Data

Q88657 - ACC Functions for Calculating and Displaying Date-Time Values