write a function in Excel that calculate the actual working hours between two date intervals .

Đã hoàn thành Đã đăng vào 4 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

write a function in Excel that calculate the actual working hours between two date intervals. excluding the weekends and the non working hores.

The weekend days are Friday and satrday

The working houres are Sunday to Thursday from 8:00 AM to 2:15 PM.

in the attachment you will find a sample of date.

your job is to write a function that can calculate the actual working houres.

Excel Xử lí dữ liệu Nhập liệu Visual Basic

ID dự án: #23018903

Về dự án

14 đề xuất Dự án từ xa 4 năm trước đang mở

Được trao cho:

zealotmk

Hi I already have the similar function written with me for this in excel vba. Please leave me a message if you wish to hire me so that i can provide you the code in 0 days

$20 USD trong 1 ngày
(7 Đánh Giá)
3.1

14 freelancer chào giá trung bình$21 cho công việc này

belalihabibullah

Hi, I read your requirement.I have good experience in function in Excel that calculate. I would like to work on this project and can complete with 100% accuracy with in the time frame, waiting for your reply ab Thêm

$25 USD trong 0 ngày
(60 Nhận xét)
5.6
paulodayto08

Hi Good Day! A serious freelancer here. I want to help you with this. I can create a formula to compute the number of Actual working hours. Please consider my bid. I've done a lot of Reports and Templates using MS Ex Thêm

$20 USD trong 1 ngày
(61 Nhận xét)
5.1
USAWebExpert

Hi There, I have 7 years of experience in excel,I will put the formulas for calculating the working hours as you required. Need to discuss over chat PM?

$60 USD trong 7 ngày
(11 Nhận xét)
4.1
Amrsamra

Hello I*`m CMA holder and financial analyst can u msg me please to share some details ty

$20 USD trong 7 ngày
(16 Nhận xét)
3.7
SupremeWriters

Hi... I have gone through your project specification you have provided and it seems like it is doable for me. I am a professional and experienced writer who would like to work on your project. You will get your work do Thêm

$10 USD trong 1 ngày
(3 Nhận xét)
1.9
athulskarun

Hello. I hope you're doing good. I like to work with you in a mutually beneficial manner and improve my portfolio. I'm an experienced and well-established freelancer. I've worked with 30+ clients in the past year alon Thêm

$20 USD trong 7 ngày
(1 Nhận xét)
0.0
prajna6669

Dear Client, Hope you are doing great! It would be my pleasure to work for you. This looks to be a super easy activity. I would request you to kindly honour me with this activity. I will ensure that the delivered produ Thêm

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
anuragbasu076

I wanr to work and i want ti earn money from your app And i a student My name is anurag Iam in college

$10 USD trong 2 ngày
(0 Nhận xét)
0.0
VINOTHSARAN

I have experience in value streaming Mapping where I use to calculate NVA by avoiding non working hours calculated using spreadsheet

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
shivamd5896

I am trained data entry operator. I can finish your work in the given Time frame. You can trust me. I am an honest person.

$20 USD trong 2 ngày
(0 Nhận xét)
0.0