try below
=IF(C10="Rest Day","DFL RDFLEXI","DFL"&TEXT(C10,"HHMM")&"HRS")
you can use & instead of concatenate
try below
=IF(C10="Rest Day","DFL RDFLEXI","DFL"&TEXT(C10,"HHMM")&"HRS")
you can use & instead of concatenate
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks