output decimal as days:hours:minutes

[baneaic]

I'm trying to create a form that will allow a user to enter certain
job specifications (# of pages and # of copies) and then have a field
that will automatically calculate how long that job will take to run
(on a machine which runs at a given number of copies per minute). I
have seen very short, control source statement that will format to
hours:minutes, but I do not know how to make it format to
days:hours:minutes, and most of the jobs this database will be used
for will run over days. The way I have it set up, I get something
like 13.72 instead of 1 day: 13 hours: 43 minutes.

Here is a sample of the control source code I've seen used for a
similar problem on another forum (to solve hours:minutes).

= int([FieldName]) & Format((([FieldName] - int([FieldName]))) * 60,"#:
00")

That works great for the hours/minutes if it is less than 24 hours.
Over that, and it doesn't roll over into days.

[Allen Browne]

Doug Steele has a more complete DateDiff() function here:
http://www.accessmvp.com/djsteele/Diff2Dates.html

For a basic explanation of what's going on, see:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ba*****@yahoo.comwrote in message
news:11**********************@s48g2000cws.googlegr oups.com...

I'm trying to create a form that will allow a user to enter certain
job specifications (# of pages and # of copies) and then have a field
that will automatically calculate how long that job will take to run
(on a machine which runs at a given number of copies per minute). I
have seen very short, control source statement that will format to
hours:minutes, but I do not know how to make it format to
days:hours:minutes, and most of the jobs this database will be used
for will run over days. The way I have it set up, I get something
like 13.72 instead of 1 day: 13 hours: 43 minutes.

Here is a sample of the control source code I've seen used for a
similar problem on another forum (to solve hours:minutes).

= int([FieldName]) & Format((([FieldName] - int([FieldName]))) * 60,"#:
00")

That works great for the hours/minutes if it is less than 24 hours.
Over that, and it doesn't roll over into days.