Help needed: Calculated field Question

%3CLINGO-SUB%20id%3D%22lingo-sub-2010423%22%20slang%3D%22en-US%22%3EHelp%20needed%3A%20Calculated%20field%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010423%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3EI%20have%20a%20calculated%20field%20that%20counts%20hours%20between%202%20date%2Ftime%20fields%3CBR%20%2F%3Ehere%20is%20my%20formula%3CBR%20%2F%3E%3DTEXT(%5Bdate%20of%20cover%5D-coverdate_till%2C%22hh%3Amm%22)%3C%2FP%3E%3CP%3Ebut%20it%20is%20calculating%20when%20there%20is%20no%20date%20entered%20in%20the%202nd%20Date%2FTime%20field%20and%20i%20need%20it%20to%20show%20zero%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20greatly%20appreciated%3CBR%20%2F%3EGary%3CBR%20%2F%3EPs%20i%20know%20nothing%20about%20calculated%20field%20formula%20other%20than%20a%20basic%20level%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2010423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi All

I have a calculated field that counts hours between 2 date/time fields
here is my formula
=TEXT([date of cover]-coverdate_till,"hh:mm")

but it is calculating when there is no date entered in the 2nd Date/Time field and i need it to show zero

Any help greatly appreciated
Gary
Ps i know nothing about calculated field formula other than a basic level

0 Replies