Forum Discussion
Converting excel data into a printable calendar template
Hello - I realize some time has passed since this thread. But I'm wondering if you can help with the file you created called Berlin Mara. I'm adding some columns and one of them is a time column. When I enter it at as a time it formats to a decimal. =[@team]&" (vs) "&[@Opponent]&" "&[@Time] Is there a different way I need to write the formula so that it keep the time format?
Thank you.
hooknk If I understand you correctly you should wrap the time par of your formula in the TEXT function so that you can specify the time format. Like this:
=[@team]&" (vs) "&[@Opponent]&" "& TEXT( [@Time], "hh:mm:ss" )
- Actually - I figured it out! Again thank you for all the help you've given!!
That worked awesome! - however is there way to not make it military time? And to include the am or pm label? - Also - this has been great. I can't thank you enough for the help.