Salam
Mujy excel ka 1 formula chahiye
1 raqam hai 100.246
Is me se 100 automaticaly minus ho jaye aur .246 agy cell me ajaye jahan formula lagayen
Salam
Mujy excel ka 1 formula chahiye
1 raqam hai 100.246
Is me se 100 automaticaly minus ho jaye aur .246 agy cell me ajaye jahan formula lagayen
TWEETER ID @DISH_FTA
=A2-TRUNC((A2))
There are 3 shifts, Every shift needs change duty after a Week (Sunday) of the month through 24:00 hrs. as given below detail.
Date: Friday,01/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Saturday,02/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Sunday,03/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Monday,04/12/2017 (Duty Shift would be Changed)
Shift:A 16:00 TO 24:00 hrs (Evening-duty)
Shift:B 00:00 TO 08:00 hrs (Night-duty)
Shift:C 08:00 TO 16:00 hrs (Morning-duty)
Please help me that how to set formula in excel that will show me Shifts: A, B or C will perform their duties on given date in 24:00 hrs.
- - - Updated - - -
There are 3 shifts, Every shift needs change duty after a Week (Sunday) of the month through 24:00 hrs. as given below detail.
Date: Friday,01/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Saturday,02/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Sunday,03/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Monday,04/12/2017 (Duty Shift would be Changed)
Shift:A 16:00 TO 24:00 hrs (Evening-duty)
Shift:B 00:00 TO 08:00 hrs (Night-duty)
Shift:C 08:00 TO 16:00 hrs (Morning-duty)
Please help me that how to set formula in excel that will show me Shifts: A, B or C will perform their duties on given date in 24:00 hrs.
Hello guys,
I have need a help to you please. as given below task.
Sum 1st date:
Today figure 4
To Month 4
To Year = 4
Sum 2nd date:
Today figure 2
To Month 6
To Year = 6
Sum 3rd date:
Today figure 0
To Month 6
To Year = 6
Now, My last Yearly figure remain same as I plus or minus figure in today's figure. it may go auto sum upto date. please tell me formula or condition for that. In advance thanks.
Bookmarks