Jul 09 2021 08:25 AM
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
Jul 09 2021 08:51 AM
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.
Jul 09 2021 08:53 AM
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.
Jul 09 2021 12:05 PM
Jul 09 2021 12:25 PM
Jul 09 2021 12:43 PM
Interesting. Do you know Excel version for which MOD() is not available?
Jul 09 2021 12:52 PM