Forum Discussion
Comment convertir des heures et minutes >24 en décimal ?
Bonjour,
Je cherche à convertir un nombre d'heures mensuel travaillées en format digital par exemple 165:05
Est-ce que quelqu'un peut m'aider ?
Merci d'avance
6 Replies
This formula also goes beyond the day.
For example, if work starts at 6:00 p.m. and work ends at 5:00 a.m. on the next day,
it will calculate correctly.
Formula:
=IF(C3<B3,((C3+1)-B3)*24,(C3-B3)*24)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- Hello Mr. Baklan, yes you are right,
but I wasn't sure whether the function works with all Excel versions
and since there is no information about the Excel version that is being used,
I wanted to be on the safe side.
With the MOD function it is certainly easier and more elegant.
Thanks
To display time over 24 hours, for example 165:05, apply the custom format [h]:mm
If you want decimal hours, use a formula to multiply the time with 24 and format the cell with the formula as General or as Number.
