|
|
| Re: Bus Route Profiles Released By NYC Comptroller Scott Stringer (326943) | |||
 |
|||
| Home > BusChat | |||
|
[ Read Responses | Post a New Response | Return to the Index ] |
|
||
|
Re: Bus Route Profiles Released By NYC Comptroller Scott Stringer |
|
|
Posted by Stephen Bauman on Wed Jan 3 21:07:58 2018, in response to Re: Bus Route Profiles Released By NYC Comptroller Scott Stringer, posted by checkmatechamp13 on Wed Jan 3 18:42:22 2018. Also, for some reason, Excel reads the revenue hours as some sort of date.The time interval is a date format. Check to see, if the Excel date format matches the time interval. If it does, there are functions that will permit your to extract days, hours, minutes, etc. from the date. Dates are stored as a decimal number. The days are whole numbers and the hours, mins, secs are fractional. See what date corresponds to a value of 0. That should help you decode the date part. |
|
(There are no responses to this message.)
|
|