Logging man-days in a time sheet

[lcastanheiro]

Hi, I am trying to automate a time sheet to log man-days based on the hours worked. The timesheet has start and stop time, based on which calculates the hours worked and it should return the value in man-days based on the following condition:

Work :	log as:
Less or equal to 2 hrs.	0.00​	days
3 hrs	0.25​	days
4 hrs	0.50​	days
5 hours	0.75​	days
More than 6 but less than 10 hrs.	1.00​	days
11 Hours	1.25​	days
12 hours	1.5​	days
13 hours	1.75​	days
14 hours	2​	days

How do I elegantly do that?

Thanks for your help.

 

[Skybluekid]

Try using an IFS Statement

Book1
	C	D
3	Hours
4	5	0.75 Days
5	2	0.00 Days
6	1	0.00 Days
7	9	1.00 Days
8	10	1.00 Days
9	14	2.00 Days
10	12	1.50 Days
11	3	0.25 Days
12	8	1.00 Days
Sheet1

Cell Formulas
Range	Formula
D4:D12	D4	=IFS(C4<=2,0,C4=3,0.25,C4=4,0.5,C4=5,0.75,AND(C4>=6,C4<=10),1,C4=11,1.25,C4=12,1.5,C4=13,1.75,TRUE,2)

 

[lcastanheiro]

Try using an IFS Statement

Book1
	C	D
3	Hours
4	5	0.75 Days
5	2	0.00 Days
6	1	0.00 Days
7	9	1.00 Days
8	10	1.00 Days
9	14	2.00 Days
10	12	1.50 Days
11	3	0.25 Days
12	8	1.00 Days
Sheet1

Cell Formulas
Range	Formula
D4:D12	D4	=IFS(C4<=2,0,C4=3,0.25,C4=4,0.5,C4=5,0.75,AND(C4>=6,C4<=10),1,C4=11,1.25,C4=12,1.5,C4=13,1.75,TRUE,2)

Hi

Skybluekid thank you so much. it works liek a charm.​