Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Access 2003 How to convert hours - minutes - seconds  to minutes

Posted on 2006-11-13
Medium Priority
1,431 Views
Hello,

I import a text file that give me time formated h:mm:ss which is good.  I can see all calls for a day and have a total of say 5:19:23.  What I want to do is to convert h:mm:ss to only minutes?

How do I covert it to minutes??

Thanks

Bill
0
Question by:bjennings
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 44

Expert Comment

ID: 17932664
=Hours(totaltime)*60 +Minutes(totaltime) + IIf(Seconds(totaltime)>29,1,0)
0

LVL 44

Expert Comment

ID: 17932671
In this case I condsidered the seconds portion of totaltime and rounded it up to 1 it 30 seconds or more.

0

LVL 9

Expert Comment

ID: 17932694
You didn't say what you wanted to do with the seconds.  This trucates.

Public Function HHMMSS_To_Minutes(ByVal sTime As String) As Integer
Dim col1stColon As Integer
col1stColon = InStr(sTime, ":")

Dim iHours As Integer
iHours = Left(sTime, col1stColon - 1)
Dim iMins As Integer
iMins = Mid(sTime, col1stColon + 1, 2)

' ignores seconds
HHMMSS_To_Minutes = (iHours * 60) + iMins
End Function
0

LVL 16

Expert Comment

ID: 17933140
Sub ConvertTimeToMinutes()
Dim tim As Date
tim = #1:05:30 AM#
Debug.Print tim * 1440
End Sub

If you want to round the result encapsulate the last line with the round function like this...

Debug.Print Round(tim * 1440,2)

In any case the short answer is take your date/time variable and multiply it by 1440.  The result will be the number of minutes that that date/time variable contains.

Be aware, that trying this against a date like today's date will result in a very large number.  I presume that you're trying to deal with much smaller numbers (difference between two date & times but if not you may need to decide how many days in the date portion of the field you want to include.

0

LVL 44

Accepted Solution

GRayL earned 1000 total points
ID: 17933693
Sorry, remove the s from each of my functions:

=Hour(totaltime)*60 +Minute(totaltime) + IIf(Second(totaltime)>29,1,0)
0

Author Comment

ID: 17938564
Thank you so much everyone!!!  GRayl was the easiest solution!
0

LVL 44

Expert Comment

ID: 17939796
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
###### Suggested Courses
Course of the Month10 days, 15 hours left to enroll