Time Conversion from hours to minutes

[Guest]

I have a table in which I have entered in a time in and time out. I want to
run a report that will show how many minutes were spent. I can get a formula
to show how many hours and minutes but not the total minutes. Instead of
1:20 I need it to show 80. Is that possible and if so can someone help me
out.

 

[Douglas J. Steele]

Try DateDiff("n", [TimeIn], [TimeOut])

 

[Jason Lepack]

Are these "times" (ie. 1:20, 24:30, etc) or "dates and times" (ie.
1/1/2007 11:00, 12/25/2006 9:30, etc)

If they are just "times" then you're going to have an issue if your
timein is on a different day than timeout.

Other than that use Doug's suggestion.

Cheers,
Jason Lepack

Try DateDiff("n", [TimeIn], [TimeOut])

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

I have a table in which I have entered in a time in and time out. I want
to
run a report that will show how many minutes were spent. I can get a
formula
to show how many hours and minutes but not the total minutes. Instead of
1:20 I need it to show 80. Is that possible and if so can someone help me
out.

- Show quoted text -

 

[Guest]

Yes they are times. I don't need need to worry about dates because
everything happens on the same day and usually is under an hour but I need to
have the minutes so I can add them up. I'm tring to first find the minutes
from lets say 1:40 pm to 2:30 pm which would be 50 minutes and then later I
will have to add up the minutes to get a total. I hope that made sense.
Thanks for helping me out with this.

--
Thanks, Joy

Are these "times" (ie. 1:20, 24:30, etc) or "dates and times" (ie.
1/1/2007 11:00, 12/25/2006 9:30, etc)

If they are just "times" then you're going to have an issue if your
timein is on a different day than timeout.

Other than that use Doug's suggestion.

Cheers,
Jason Lepack

Try DateDiff("n", [TimeIn], [TimeOut])

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

I have a table in which I have entered in a time in and time out. I want
to
run a report that will show how many minutes were spent. I can get a
formula
to show how many hours and minutes but not the total minutes. Instead of
1:20 I need it to show 80. Is that possible and if so can someone help me
out.

- Show quoted text -

 

[Jason Lepack]

So you create one query that uses Doug's method, DateDiff("n",
[TimeIn], [TimeOut])

Then you cretae a new query and add in the query that you just created
and sum that column that you calculated in the first one.

Cheers,
Jason Lepack

Yes they are times. I don't need need to worry about dates because
everything happens on the same day and usually is under an hour but I need to
have the minutes so I can add them up. I'm tring to first find the minutes
from lets say 1:40 pm to 2:30 pm which would be 50 minutes and then later I
will have to add up the minutes to get a total. I hope that made sense.
Thanks for helping me out with this.

--
Thanks, Joy

Are these "times" (ie. 1:20, 24:30, etc) or "dates and times" (ie.
1/1/2007 11:00, 12/25/2006 9:30, etc)

If they are just "times" then you're going to have an issue if your
timein is on a different day than timeout.

Other than that use Doug's suggestion.

Cheers,
Jason Lepack

Try DateDiff("n", [TimeIn], [TimeOut])
--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

I have a table in which I have entered in a time in and time out. I want
to
run a report that will show how many minutes were spent. I can get a
formula
to show how many hours and minutes but not the total minutes. Instead of
1:20 I need it to show 80. Is that possible and if so can someone help me
out.

- Show quoted text -

 

[Guest]

Jason and Douglas,

I want to thank you both so much for helping me out!!! I was tring to use
that method in a report. It works perfectly in a query. Just what I
needed.
--
Thanks, Joy

So you create one query that uses Doug's method, DateDiff("n",
[TimeIn], [TimeOut])

Then you cretae a new query and add in the query that you just created
and sum that column that you calculated in the first one.

Cheers,
Jason Lepack

Yes they are times. I don't need need to worry about dates because
everything happens on the same day and usually is under an hour but I need to
have the minutes so I can add them up. I'm tring to first find the minutes
from lets say 1:40 pm to 2:30 pm which would be 50 minutes and then later I
will have to add up the minutes to get a total. I hope that made sense.
Thanks for helping me out with this.

--
Thanks, Joy

Are these "times" (ie. 1:20, 24:30, etc) or "dates and times" (ie.
1/1/2007 11:00, 12/25/2006 9:30, etc)

If they are just "times" then you're going to have an issue if your
timein is on a different day than timeout.

Other than that use Doug's suggestion.

Cheers,
Jason Lepack

On May 31, 12:00 pm, "Douglas J. Steele"
Try DateDiff("n", [TimeIn], [TimeOut])

I have a table in which I have entered in a time in and time out. I want
to
run a report that will show how many minutes were spent. I can get a
formula
to show how many hours and minutes but not the total minutes. Instead of
1:20 I need it to show 80. Is that possible and if so can someone help me
out.

- Show quoted text -- Hide quoted text -

- Show quoted text -