Convert MFP Date/Time to ISO Date/Time in Excel [SOLVED}
Pages:
1
Actions
Choose an action
Print
#1 by flanna on 26 Jan 2016
Anybody know how to convert MFP Date/Time (i.e. event_off) to standard Date/Time format in Excel?
flanna
#2 by MarkV on 26 Jan 2016
Hi
Just format the Excel cell range to date and time, or use CTRL# or CTRL@
example:
42395.63805 = 26-Jan-16 15:18:47
MarkV
#3 by flanna on 26 Jan 2016
Thanks MarkV. It is very simple and it works.
flanna
Pages:
1
Actions
Choose an action
Print
Desktop View
Hello Guest
Home
Recent Posts
Register
Login
Mobile View