Forumi


Povratak   PC Ekspert Forum > Računala > Software > Web dizajn, programiranje i ostalo
Ime
Lozinka

Odgovori
 
Uređivanje
Staro 30.01.2012., 19:55   #1
uploader
Premium
Moj komp
 
uploader's Avatar
 
Datum registracije: Oct 2006
Lokacija: Germany
Postovi: 694
MS Access, vrijeme vece od 24h (trebam pomoc)

pronasao sam nesto na internetu ali neznam to primjeniti, trebam nekog tko se malo bolje kuzi u access da mi pomogne kako da ovo dolje iskoristim za svoju tablicu!?
______________________________________________________________
You want Access to store HOURS and MINUTES, while the Date/Time field type stores DATES and TIMES. Any time over 24:00 is not valid. Here's a suggestion: define your fields as Double, and store the total number of minutes. (A Double field can hold a number up to 2,147,483,647.) Then prepare a couple of functions to get your data in and out, formatted as you like. For example, this function will accept the minutes and convert to hours and minutes in the format hhhh:mm. You'll need to write one that converts the other way so you can give it hhhh:mm and it will return the total minutes.

Public Function MinutesToHM(incoming As Double) As String

MinutesToHM= Int(incoming / 60) & ":" & _
Format(Int((incoming) - (Int(incoming / 60) * 60)), "00")

End Function
_______________________________________________________________
uploader je offline   Reply With Quote
Oglas
 
Oglas
Oglasni prostor

Odgovori


Uređivanje

Pravila postanja
Vi ne možete otvarati nove teme
Vi ne možete pisati odgovore
Vi ne možete uploadati priloge
Vi ne možete uređivati svoje poruke

BB code je Uključeno
Smajlići su Uključeno
[IMG] kod je Uključeno
HTML je Isključeno

Idi na