Hi there. I'm an airline pilot and my company just switched the software that tracks our pay. I am creating a new spreadsheet to keep track of my pay. I am importing the data from the new software and then applying our contract pay rules to come up with totals. I have encountered a difficult data field provided by the imported data. It is providing our aircraft IN and OUT times in the following UTC (universal time cooridinate) format:
2016-01-02T11:30:00.0000000
Where:
"2016-01-02" is the date in year-month-day format
and:
"T11:30:00.0000000" is the time in hour:minute:second.decimal_seconds format.
I need a function that will split this data up into separate date and time fields. The date format can remain the same as long as everything after the "T" is eliminated. The time can be simplified to just hours and minutes, as the seconds portion is always zero.
Any help would be appreciated. Thanks.
Geoff
Bookmarks