Why not using something like: =FORMAT(T Written by Johan. Please Rate Vote 1 Vote 2 Vote 3 Vote 4 Vote 5 Why not using something like: =FORMAT(TIME(0,0,FactTable[DurationInSec]),"hh:mm:ss")