Excel & Business Math 30: Payroll Time Sheets, IF Function, Sheet Reference for Overtime & Gross Pay

Поделиться
HTML-код
  • Опубликовано: 6 сен 2024

Комментарии • 35

  • @danrab1453
    @danrab1453 6 лет назад +5

    You have GREAT/ AWESOME videos.
    PLEASE keep them coming!!!
    I've learned a lot!

    • @excelisfun
      @excelisfun  6 лет назад

      Ok. I will keep making them if you keep supporting : ) I am glad that you learned a lot and thanks for the support with your comment, Thumbs Up and Sub : )

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 6 лет назад

    Thanks Mike for this EXCELlent video

    • @excelisfun
      @excelisfun  6 лет назад

      You are welcome, most supportive Teammate!!!!

  • @MalinaC
    @MalinaC 6 лет назад

    I love your 3-clicks explanation :)

    • @excelisfun
      @excelisfun  6 лет назад +1

      Yes, after teaching Sheet References for 20 years, it is the universal mistake that almost all of us make the first time we try it - I know I made it... Thanks for watching, Teammate Malina!!!

    • @MalinaC
      @MalinaC 6 лет назад

      Totaly agree :)
      Thank you as well:)

  • @ismailismaili0071
    @ismailismaili0071 6 лет назад +1

    Mr. Mike Thank you so much for the video please how to do round on time?

    • @excelisfun
      @excelisfun  6 лет назад

      You are welcome! Keep watching, next few videos show that : )

  • @aamir6282
    @aamir6282 6 лет назад

    i love your busniss math series

    • @excelisfun
      @excelisfun  6 лет назад

      Glad you love it! I love making the videos - so it works out well!!! Thanks for your support on every video : )

  • @pmsocho
    @pmsocho 6 лет назад

    Thanks for the video!

    • @excelisfun
      @excelisfun  6 лет назад

      You are welcome, Teammate pmsocho!!!

  • @davidpetrella1947
    @davidpetrella1947 6 лет назад

    Thanks for the video! Is there a way to use tables to calculate gross pay for multiple job codes and pay rates in a given week?

  • @carmenchen1186
    @carmenchen1186 4 года назад

    Thank you ! Mike.

    • @excelisfun
      @excelisfun  4 года назад

      You are welcome, Carmen !!!!!

  • @rahulmajumder3102
    @rahulmajumder3102 6 лет назад

    Hi mich, can you make a video on how to prepare tracker for payable bills

  • @ricgue2073
    @ricgue2073 Год назад

    what about the tax deductons , SS and medicare ?

  • @johnborg5419
    @johnborg5419 6 лет назад

    Great Mike and Thanks :)

  • @krn14242
    @krn14242 6 лет назад

    Thanks Mike.

  • @jyotihingorani1292
    @jyotihingorani1292 4 года назад

    Hi If I have 3 pay rates, weekday- $20, Saturday- $30 and Sunday- $40. How to I calculate the daily wage, based on day of the week. Thanks

  • @ZivooYT
    @ZivooYT 6 лет назад

    Thanks a lot for these Videos!
    in my country we get extra hours after working 8 hours.
    the first 2 hours are 125% and then 150%, the daily hours counted first and then the weekly(42 is the maximum).
    also when working on night shift the 7th hour is 125% as well.
    could you please explain how to do this kind of calculation?
    best regards!

  • @MT0912
    @MT0912 6 лет назад

    Thanks for all this! I've tried the formula for calculating hours worked in a day with the break. The actual hours worked result correct if I don't multiply by 24. I am using Office 2007. Is it correct?

  • @tingtingshi9463
    @tingtingshi9463 6 лет назад

    You are the best😘

    • @excelisfun
      @excelisfun  6 лет назад

      Thank you for your kind words and for the support with your comment, Thumbs Up and Sub : )

  • @Clifffffffffford
    @Clifffffffffford 6 лет назад

    Thanks !

    • @excelisfun
      @excelisfun  6 лет назад

      You are welcome, Clifford!!!!! Thanks for helping the excelisfun channel with your comments and Thumbs Up : )

  • @mohamedchakroun4973
    @mohamedchakroun4973 6 лет назад

    Thumbs up

  • @Vikas-oz7bi
    @Vikas-oz7bi 6 лет назад

    sir how to automatic sunday off in attendance sheet via macro code plz tell or upload excel link of attendacne sheet

    • @excelisfun
      @excelisfun  6 лет назад

      I do not know, But you can ask a more complete question here at this amazing Excel question site: mrexcel.com/forum (there are 100s of Excel masters waiting to answer your question - if it is a question that can be understood).

  • @planxlsm
    @planxlsm 5 лет назад

    4:16 10:34 19:55

  • @unisoft5956
    @unisoft5956 6 лет назад

    Mashallah

    • @excelisfun
      @excelisfun  6 лет назад

      You are welcome! Thanks for your support with your comment, Thumbs Up and Sub : )