changing time set-up

[dkent]

my excel speadsheet

the time is set up with this

 

starting time ending time

10:00 am 9:30 pm

11:30 am 12:00 pm

 

is there a code to remove the :00 if it is there?

and 12:00 pm - noon?

[step]

var start = Field("Start Time"); // Your start time field
var end = Field("End Time"); // Your end time field

var result = start  + " - " + end; // join times with a hyphen

return result.replace(/\:00/g,"").replace(/12\s+?pm/,"noon");

[dkent]

I keep getting

function dose not return a value

do you want to ignore the error and save the rule anyway?

[step]

Did you copy the rule exactly? Including the return line? and change my fields to the fields that you're using where I commented them in the code?

[dkent]

I acting a little weird but working

is the fields blank

I get

 

—

 

what the best way to remove this — if the field are blanks?

[step]

var start = Field("Start Time"); // Your start time field
var end = Field("End Time"); // Your end time field

var result = [start,end].filter(String).join(" - ");

return result.replace(/\:00/g,"").replace(/12\s+?pm/,"noon");