Forum Discussion
Time formatting in Excel
If you use the MOD formula I suggested, it will strip off the date element.
Then copy the formula results and paste values back over the original data.
Try the read into Tableau again and this time it should show as a time and not a datetime.
PeterBartholomew1 , but that doesn't work for the elapsed time.
I rather assumed elapsed time would work correctly with either the datetime or the time, provided the race is not run at midnight. Something that might require more careful handling is any gun/chip calibration errors that could be positive or negative. I am also puzzled by a timing system that times to the nearest minute; I am more used to 1/100ths of a second.
Peter, maybe I misunderstood something, but if you have Chip Time 33:33:00 you shall show it in Tableau as 33:33:00, not as 9:33:00.
Not related to this task, I checked for few minutes Tableau community forum - issue with converting Excel datetime representation into Tableau form exists, but I didn't dig details. Never worked with Tableau.
