15. Combine text and time
This example shows how to combine text and time successfully.
To combine text and time:
1. Select cell A5 and type shutdown.
2. Select cell D5 and press <-Ctrl+Shift+:-> to insert the current time.
3. Select cell A7 and type the following formula: =" Today " & A5 & " at " & TEXT(D5,"hh:mm PM").
Watch the Video Tutorial - https://www.youtube.com/watch?v=7-tPY3VG6p4
Hope You Like This Tutorial - Give Comments
People, who looking to get training course of Ms excel then this place is might be the best option for them. In fact I will definitely go for it as well.
ReplyDeletemicrosoft excel training courses in melbourne