Our partners:
ID: 8678, Pages: 1   Go Down

Author Topic: Convert MFP Date/Time to ISO Date/Time in Excel [SOLVED}  (Read 1412 times)

Tags:
flanna
  • All members
  • Posts: 68
Convert MFP Date/Time to ISO Date/Time in Excel [SOLVED}
« on: 26 Jan 2016, 11:36 »
Anybody know how to convert MFP Date/Time (i.e. event_off) to standard Date/Time format in Excel?
Logged
MarkV
  • Moderator
  • Posts: 3605
*
Re: Convert MFP Date/Time to ISO Date/Time in Excel
« Reply #1 on: 26 Jan 2016, 15:23 »
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
Logged
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.
flanna
  • All members
  • Posts: 68
Re: Convert MFP Date/Time to ISO Date/Time in Excel [SOLVED}
« Reply #2 on: 26 Jan 2016, 20:47 »
Thanks MarkV. It is very simple and it works.
Logged
Pages: 1   Go Up
 

Please note, BetFair is seems to be currently OFFLINE