i have a formula in a column to convert UTC time to local time but i also need to add a date before converted time, how can i do this.
- formula to convert time is "=MOD((F2+1)-(10/24),1)"
- would like to add date in format "30 May", just have it typed up as same for every row in a column will be good
- if possible to convert time from am/pm to a military time (24hrs)
refer to attached image for example
111.jpg
Bookmarks