Forum Discussion

Baz286's avatar
Baz286
Copper Contributor
Apr 14, 2021
Solved

Multiply Hours and Minutes by a number

I have setup a spreadsheet to monitor my staff's holiday hours. I have formatted the cells using [h]:mm and also used the 1904 date system.  My problem is that, when trying to multiply the hours by ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 16, 2021

Baz286 , you are welcome, glad to help

Baz286's avatar
Baz286
Copper Contributor
Jul 22, 2021

SergeiBaklan 

Hello again,
May I seek your advice once again regarding calculating hours and minutes.
I have been taking your advice regarding calculating time however, on addition, it does not calculate properly.
I am using Windows 10 Pro, Excel 2016.
I have attached a file showing my calculations. I would welcome your advice on adapti g the correct formula.

Regards,
Barry Nelson

  • BishoyZ's avatar
    BishoyZ
    Copper Contributor
    Apr 12, 2024

    SergeiBaklan 

           
     Shift StartShift EndShift hoursCrew SizeTotal hours 
           
     9:00 AM5:00 PM810  
     8:00 AM5:00 PM912  
           
           
           
           
           

     

    Hey Sergei,

     

    I need your help to format this excel sheet to calculate the total hours for each day for my cleaning business. I really appreciate your help so much with this.

     

    Thanks

    Bishoy Zaky

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 22, 2021

    Baz286 

    Barry, formulas looks correct, I'd only not to hardcode constants like TIME(10,46,0) and keep then in separate cells somewhere outside. Otherwise you need to correct every formula if the constant changes.

     

    Sure, everything in Excel could be done by few different ways. Stay on formulas you are more familiar with if they give correct results.