Once again thank you and Have a great day….
19th October 2011 From Kuwait, Kuwait
Does anybody out here working for a fresh vegetable and fruits company’s sales department? If so, could you please send me a sample or selling products and services presentation!
I would be very grateful, even if you could point out the headings.
Thank you in advance.
23rd March 2012 From Kuwait, Kuwait
Can you please help me solving my problem?
I need to get Total Number of Lates (meaning calculation of lates in minutes/hour.
Required Time = 09:00 (in morning) 14:00 (in afternoon) *in case they come in halfday
Grace Period = 00:15
I solve already the formula on getting the tardiness
"A" = Required Time 1) (09:00)-AM and 2)14:00 PM
"B" = Actual Time 1) (09:16)-AM and 2) 14:15 PM
1) B-A = 00:16
2) B-A = 00:15
My problem is how will I combine this both formula in one cell that will compute all lates that excess 00:15 and will show on the other cell if its late or on time...
16th April 2012 From Philippines, Makati
Where in i Mark Weekly offs as W and Leave as L.
Using countif formula i calculate number of Leave taken during a month.
I am having one problem If one employee takes leave on Saturday and Monday my Excel shows like this L,W,L , then my leave should be 3 and weekly off should be 3( if there are 4 weekly offs in a month)
i need an If condition formula , can you help
23rd January 2017 From India, Thane
help me on this,
i want a formula in attendance sheet where i get halfday calculation in today present days.
for ex-4 woff , 25 present.0 absent and 1 halfday so in my excel showing - total days present -30
but i need to get total days present -29.5
15th May 2018 From India