SPO calculated column due date hours and days

%3CLINGO-SUB%20id%3D%22lingo-sub-1668305%22%20slang%3D%22en-US%22%3ESPO%20calculated%20column%20due%20date%20hours%20and%20days%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1668305%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20need%20to%20setup%20a%20Due%20Date%20calculated%20column%20on%20an%20SPO%20list%20and%20whilst%20I've%20managed%20to%20work%20out%20the%20formula%20for%20days%2C%20I%20cant%20quite%20work%20out%20hours%3F!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20have%20SLA%20priorities%20on%20my%20list%20as%20per%20the%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E5%3D%20365%20days%3C%2FP%3E%3CP%3E4%3D%205%20days%3C%2FP%3E%3CP%3E3%3D%205%20days%3C%2FP%3E%3CP%3E2%3D%201%20day%3C%2FP%3E%3CP%3E1%3D%208%20hours%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3DIF(Priority%3D%225%22%2CCreated%2B365%2CIF(Priority%3D%224%22%2CCreated%2B5%2CIF(Priority%3D%223%22%2CCreated%2B5%2CIF(Priority%3D%222%22%2CCreated%2B1%2CIF(Priority%3D%221%22%2CCreated%2B0.8)))))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1668305%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello,

I need to setup a Due Date calculated column on an SPO list and whilst I've managed to work out the formula for days, I cant quite work out hours?!


I have SLA priorities on my list as per the below:

5= 365 days

4= 5 days

3= 5 days

2= 1 day

1= 8 hours

=IF(Priority="5",Created+365,IF(Priority="4",Created+5,IF(Priority="3",Created+5,IF(Priority="2",Created+1,IF(Priority="1",Created+0.8)))))

0 Replies