|
|
Date & Time - Funtion HOUR / MINUTE / SECOND
Page visited 12093 times
|
1. Work with hour, minute and second is not easy with Excel. You must remember that 1 is always 1 day ans never 1 hour.
|
|
|
|
|
|
|
|
|
2. So, if you want to convert your data in hour, you must divide all your data by 24
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
3. If you work with the minutes, you must divide by the number of minutes in a day
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
4. The usable symbols for the time format are less important than for the date. In the following document, you can find the different way to format the time
|
|
|
|
|
|
|
|
|
5. To display an hour greater than 24, you must write the format symbol h between brackets.
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
6. An other common problem with the Time ; it's the negative date.
Often, you will see this result instead of a negative date.
To solve this problem, you just have to change the parameter of the internal calendar of Excel.
|
|
|
|
|
|
|
|
|
7. In the menu Tools/Options, check in the tab 'Calculation' if the option '1904 date system' is checked
|
|
|
|
|
|
|
|
|
8. Try to find the solution of the following exercise
|
|
|
|
|
|
|
|
|
