Скачать или смотреть How to Calculate Working Hours Use MOD Function in MS Excel

How To Calculate Total Working Hours Using MOD Function in MS Excel.

What is the MOD Function in Excel?
The MOD function in Excel is used to find the remainder after dividing one number (dividend) by another (divisor). In mathematics, this operation is called the modulo operation or modulus, hence the name MOD.
Syntax:
MOD(number, divisor)
The MOD function syntax has the following arguments:
Number Required: The number for which you want to find the remainder.
Divisor Required: The number by which you want to divide the number.

Actually, the MOD Function we can use to calculate total working hours and use the formula below:
=MOD(C4-B4,1)*24

Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
♥️♥️
------------------------------------------------
#msexcel #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #statistics #exceltech #shorts #shortsviral #shortsyoutube #share #knowledge #knowledgesharing
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv