Cummulative Time

[ohmbru]

Can I format a field in my table to allow a value like 181 hours, 20 minutes, 13 seconds (181:20:13).

I want to import this from an outside source and have limitations on the output format.



Brian

 

[lupins46]

Not if you use a datetime field.
You would have to use a text field and create the text string yourself.

Times in Access represent points in time not amounts of time.

 

[ZmrAbdulla]

Create this module in your Database

Option Compare Database
Option Explicit

Public Function HrsMinsSecs(TimeVar As Double)

Dim Hrs As Long, Mins As String, Secs As String
If IsNull(TimeVar) Then
    HrsMinsSecs = Null
Else
    Mins = Format(DatePart("n", TimeVar), "00")
    Secs = Format(DatePart("s", TimeVar), "00")
    Hrs = (Fix(TimeVar) * 24) + DatePart("h", TimeVar)
    HrsMinsSecs = Hrs & ":" & Mins & ":" & Secs
End If

End Function

and Controle Source of your TextBox that display time will be

=HrsMinsSecs([FldDateEnd]-[FldDateStart])

[red]Remember your StartTime and EndTime should be Formated
"mm/dd/yy hh:nn:ss" [/red]

Credit of this code goes to the unknown creator.. Not I

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com