Can this be made into a formul as is?

**Wskip49** · 06-12-2022, 03:11 PM

How can I make this =TIME(20,20,0) &" "& Game 1 into formula, I have formatted the time as custom time and it comes out as a number but is not time .

**TMS** · 06-12-2022, 03:15 PM

Like this:

Formula:

Please Login or Register  to view this content.

**Wskip49** · 06-13-2022, 07:10 PM

I get 20,20,0 Game 1. How do I get it to show 8:20 PM Game 1

**TMS** · 06-13-2022, 07:22 PM

How do I get it to show 8:20 PM Game 1

Change the format in quotes in the Text function.

**TMS** · 06-13-2022, 07:27 PM

Try:

Formula:

Please Login or Register  to view this content.

**protonLeah** · 06-13-2022, 07:30 PM

What happens when the time and/or game number changes? Are those values coming from elsewhere?

Re: Can this be made into a formul as is?