Ausführung von Excel-Arbeiten
$10-30 USD
Paid on delivery
Hello I need 2 formulas in Excel
First is total working Hour (we use 24 hour) and second is
Number Calculate Number
to 5 hour 0
after 5 to 7 hour 1
after 7 to 9 hour 2
after 9 to 11 hour 3
Is Total Working hour 0 to 5 hour the number is 0 whe is 5 hour to 7 hour the number is 1
You see it in Print Screen.
I think for a Excel Guru is 10 min Time...
Excel 213 / 2016
When You need more Info Ask me.. I think its easy an clear..
Kind Regards
Roger
Project ID: #11208329
About the project
14 freelancers are bidding on average $21 for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi there. Lets write your formulas quickly. I am online. Waiting your message thanks.............................
Hello there! I can assist you with the formulas that you need to make that if - else statement fo yours run in excel. Feel free to message me the details.
Solution ready. Here you go - Col A ColB Col C ColD ColE Row1 Name Start Time EndTime Total Hour Number Row2 Roger 12:00 23:30 11 More
Hello. Could you please provide a sample Excel file? This is to let me know some details, like what cell format you use for time, etc. Best regards, Alexander
Dear employer I have been in this industry for 5 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I can assur More
saya akan membantu anda untuk melakuakan itu, dan saya akan membuatkannya sesuai yang anda inginkan. kepuasan anda adalah tujuan utama saya,. Terimakasih
The two-hour calculation can not be done in excel directly subtracting the two cell because it may be an error ###, must be done under some formula for calculating, and the second formula should be a conditional if not More