How to Calculate Hours Worked in Excel (Midnight Span)

Thank so much sir.

the formula doesn’t work

how can you subtract break from it ?

Gave me an answer but that was incorrect and then mate all the right answers wrong

Didn’t work

Very clear and much appreciated 👍🏻

Helpful

Thank you very much...

Hi Any possibility you could help with how to add an IF BLANK clause into this formula? would appreciate it :)

THANK YOU, THIS WAS SO EASY TO FOLLOW, AND TO APPLY TO MY WORK SHEET, THANK YOU AGAIN

finally it's found

Dude, u saved me so lot of time! ❤ u got a new loyal subscriber. 💋

Thank you!

Thank a lot

Very clear and easy to understand — thank you!! 🙏🏻

How do I subtract 30 min lunch?

I'm finding in my 2021 version of MS Excel I'm left with a percentage rather than the number of hours:mins (eg 0.33 instead of 8hrs). Can someone please tell me how to add *24 to the formula so it can display the number of hours.

Very useful thank u sir😊😊 I was tensed from yesterday and now I am relaxed 😘😘

i love you already, you just saved a graphic artist whos trying to learn another job.

thanks👍

Can I get the formula for decimal please?

This does not work when, example: You start work at 6am and finish at 6am the next day

How do i subtract lunch on the same time. Do i just add -30

Thanks

How it works to calculate with 24 hours clock instead of AM and PM hours?

Awesome! Thank you for making it so clear

Thank You very much for this video

help please .. formula start work end work = hours work.. (1.5) for "1hr 30mins" ...tnx .

Thank you

Amazing information Thanks!!!

You Sir are the Boss. My finish time is midnight and this formula worked fantastically. Thank you for this video.

This was amazingly helpful!

thanksssss

Good explanation,
Thanks

thank you so much, im suffer this for how many years to. make my time sheet when comes to overlapping time.

You are such a life saver! tons of thanks.

Thank you!

Didn't work

Hi! just a question can you show us how to deduct hours on any time for example 1 want to deduct 2 hours from 12:00am or 1am

hope you can helps us Thank you! more power

Good video, I mostly got the way it was presented. However, I missed the logical step behind the "+1" in the formula.
Does Excel read it as "+1 day" as initially I thought it would read it as "+1 hour" and was wondering how it would work logically?

Nice video

this was very helpful in fasten my work while working with hours of shift staff for Appraising purposes mainly in the analyzation of their attendances.... Well done

CovidImages need to be invested more than half19

Thank you for this video. Very helpful and useful.