Forum Discussion

Carol1805's avatar
Carol1805
Copper Contributor
Jul 09, 2021

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
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jul 09, 2021

Carol1805 

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.

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Jul 09, 2021
      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
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 09, 2021

        NikolinoDE 

        Interesting. Do you know Excel version for which MOD() is not available?

Resources