Комментарии:
What else do you want to learn in Excel? Let me know below in the comments!
ОтветитьU r super
ОтветитьHey TTT you really sound like my favourite band KKK, but seriously though it sounds like i heard someone from a certain website of black and orange
Ответить👍
Ответитьwhat about the night shift that works past midnight?
ОтветитьIf you don't mind whatsapp number please
ОтветитьMasha Allah (WoW)
ОтветитьWhat if in one cell it has10 am - 8 pm what is the Excel formula to calculate this hour
Ответитьlol but what about substracting a smaller number AM from a larger number PM, isnt this a thing to speak about or show example also?? like Start time: 9 PM and End time 2 AM... how do you do this?
ОтветитьBonza mate, worked like a charm, thanks muchfully :0)
ОтветитьThank you. Very precise tutorial. What if I need the result in days, hours & minutes?
ОтветитьThank you so much
Ответитьhow do you calculate the total timing worked ? base on the above example
Ответитьhow to you calculate the total timing pend ? base on the above example
Ответитьhow can i write a formula that only compares 2 cells in a given row that will have 4 values? For example, cell B1 has a value of 6 and C1 has a value of 2. the "Difference cell" will total C1-B1 = -4. then when i add a value of 3 into cell D1 of 3, the "difference cell" will total D1-C1 = 1. then when i add a value of 3 into cell E1, the "difference cell" will total E1-D1 = 0. Hope this makes sense lol
Ответить