Thanks, Ibrahim! 🙏👍 Look, there really can be many different solutions about this subject in Excel. It seems simple, but in fact it can become something very complex. Lol Thanks for the comment. I hope the video helped you!
The empty Time In and Time Out cells that do not have a value (time) show a number in the Total column (Example: 1.04). How do you add to the final formula to tell it that if the Time In and Time Out cells are blank to show the Total cell as blank?
How do you calculate the the total hours? So for the first examble I3 to I9? Thank you for posting this type of situtation, because it is really not that straight forward for normal users like me... 🙂😅
This is something new , usually i would use =(endtime+1- start time) for values that are zero. This is great 👍
Thanks, Ibrahim! 🙏👍 Look, there really can be many different solutions about this subject in Excel. It seems simple, but in fact it can become something very complex. Lol
Thanks for the comment. I hope the video helped you!
@@JopaExcel yes i do agree with you on how complex it is to work with Time in excel.
Sir. Your contact is very useful... Love you.... God bless you 🙏🙏
The empty Time In and Time Out cells that do not have a value (time) show a number in the Total column (Example: 1.04). How do you add to the final formula to tell it that if the Time In and Time Out cells are blank to show the Total cell as blank?
I was searching this video from last one week
Glad it was useful, Jonathan Wick! 🙏👍
How do you calculate the the total hours? So for the first examble I3 to I9? Thank you for posting this type of situtation, because it is really not that straight forward for normal users like me... 🙂😅
Good