1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Public Function HeureToDec(pHeure As Date) As Single
Dim nbHeures As Integer, nbMinutes As Integer, nbSecondes As Single
nbHeures = DatePart("h", pHeure, vbMonday, vbFirstFourDays)
nbMinutes = DatePart("n", pHeure, vbMonday, vbFirstFourDays)
nbSecondes = nbMinutes * 60 + DatePart("s", pHeure, vbMonday, vbFirstFourDays)
nbSecondes = nbSecondes / 3600
HeureToDec = nbHeures + nbSecondes
End Function
Public Function DecToHeure(pHeure As Single) As Date
Dim nbHeures As Integer, nbMinutes As Integer, nbSecondes As Single
nbHeures = Int(pHeure)
nbSecondes = (pHeure - nbHeures) * 3600
nbMinutes = Int(nbSecondes / 60)
nbSecondes = nbSecondes - (nbMinutes * 60)
DecToHeure = TimeSerial(nbHeures, nbMinutes, nbSecondes)
End Function |
Partager