Solved

Capturing minutes and seconds only?

Posted on 2011-02-21
17
254 Views
Last Modified: 2012-05-11
Hi all,

How would I do this?  I have a time field which I have set the format to nn:ss but entering 05:45 becomes 05:45:00 - How do I get around this?  

Regards

Chris
0
Comment
Question by:smods
  • 5
  • 4
  • 3
  • +4
17 Comments
 
LVL 15

Expert Comment

by:Simon Ball
ID: 34941617
enter it as 00:05:45?
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 34941623
you might need to give more detail?  could you convert your time to just seconds and store it as an integer?
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34941647
Chris,

Try this format:

=Format(Now(),"m:s")

Sincerely,
Ed
0
 

Author Comment

by:smods
ID: 34941684
Hi guys,

Sorry I wasn't clear! It's for capturing an average transaction time.  If possible I wouldn't want to enter it as 00:05:45

Regards

Chris
0
 
LVL 77

Expert Comment

by:peter57r
ID: 34941720
There isn't any way of entereing just minutes and seconds into a time field.  As you have found , Access will always treat such an entry as hours and minutes.

You can use the technique suggested by Sudonim or you can use two fields, one for minutes and one for seconds and then build the time value in code.

Or you can use the afterupdate event of the entry and rebuild the time using..

me.textboxname= timeserial(0, Hour(me.textboxname), minute(me.textboxname))
0
 

Author Comment

by:smods
ID: 34941747
could you convert your time to just seconds and store it as an integer?

So would I enter the time but in seconds? The two text box solutions doesn't sound ideal.  How would I do this?
0
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 34941778
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34941780
I am sorry Chris for my first post.

Yeap, I agree with Peter. Date/Time field allows only entry for a day and a time.

If you want to view elapsed time and showing it in minute:seconds then you change the date/time field into a number and enter the elapsed time in seconds. Then, calculate the value into minute:second for display purposes.

Ed

0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:smods
ID: 34941809
Thanks Ed.  How would I do that?

Regards

Chris
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34941887
Chris,

Here it is:

Private Sub t1_AfterUpdate()
Me.MinSec = Me.t1 / 86400
End Sub

t1 = Field name of where you enter the elapsed values in seconds
MinSec = Unbound field that display the minutes:seconds

You need to format the MinSec field with "m:s".

Sincerely,
Ed
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34941929
Replace  Me.MinSec = Me.t1 / 86400 witht the code below instead:


Me.MinSec = Int(Me.t / 60) & ":" & (Me.t - (60 * Int(Me.t / 60)))

Ed
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34941935
Chris,

Pratima's post at ID:34941778 provided the codes I posted above. You can refer that link for more info.

Ed
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 34942409
Here is how:

1. Apply an inputmask of:

"00:"00:00

2. Use this code:
Private Sub txtTime_Click()

  If Me!txtTime.SelStart < 3 Then
    Me!txtTime.SelStart = 3
  End If
  Me!txtTime.SelLength = 1
  
End Sub

Private Sub txtTime_Enter()

  Me!txtTime.SelStart = 3
  Me!txtTime.SelLength = 1
  
End Sub

Open in new window


/gustav
0
 
LVL 39

Expert Comment

by:als315
ID: 34942444
Why not to use something like this?
DB26835639.accdb
0
 

Author Closing Comment

by:smods
ID: 34942689
Works like a charm!

Many thanks!!

Chris
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 34942713
You are welcome!

/gustav
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 34942881
nice work all.
that will teach me to take a long lunch break :)
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now