Convert HH:MM to seconds

  • Thread starter Thread starter DF
  • Start date Start date
D

DF

Sorry...one more question.

How do I convert HH:MM to seconds?

I was using

TSeconds: DateDiff("s",[EIN],[EOut])

but when EIN is, say 19:24 and EOut is 1:05 [24 hour
format], I get negative seconds.

I also have this --- TotalTime: Format([EIN]-[EOUT],"Short
Time") which gives me correct HH:MM in both
circumstances, so if I could get the total seconds from
it, I'd be ok.

Thanks in advance for any help!
Dee
 
You can include the date in the field also and Access will then know that the time is from
the next day. Another option, is to add 86,400 seconds (24*60*60) to any negative
response. This will work as long as you never need to go beyond the next day. You could do
this using IIF to check for the negative value.
 
Thanks, Wayne...they both worked great! I appreciate the
reply!
Dee
-----Original Message-----
You can include the date in the field also and Access
Click to expand...
will then know that the time is from
the next day. Another option, is to add 86,400 seconds (24*60*60) to any negative
response. This will work as long as you never need to go
Click to expand...
beyond the next day. You could do
this using IIF to check for the negative value.

--
Wayne Morgan
Microsoft Access MVP


Sorry...one more question.

How do I convert HH:MM to seconds?

I was using

TSeconds: DateDiff("s",[EIN],[EOut])

but when EIN is, say 19:24 and EOut is 1:05 [24 hour
format], I get negative seconds.

I also have this --- TotalTime: Format([EIN]- [EOUT],"Short
Time") which gives me correct HH:MM in both
circumstances, so if I could get the total seconds from
it, I'd be ok.

Thanks in advance for any help!
Dee
Click to expand...


.
Click to expand...
 
Back
Top