the likes of:
Format(Time, "h:m:s")
or
Format(Time, "Long Time")

Thank you for your reply but i am not quite following you. Can you
be a little more specific on how I can set this formatting?

I'll do you a deal. You be more specific ('body' isn't a lot to work
on. What is a time  record? How does the cell  display multiple items?
What is the collection  a collection of?), then I will be.

At present, your function  doesn't have a return type. Give it one, so that it
returns, e.g., a date.

Once you've done this, then the standard formatting  for the cell  should work.

Alternatively, return it as a string (again, give the function a return type to
ensure this happens and also to make it clear what you are doing), with the
formatting already done inside the function.