General discussion


excel - elapsed time calculation over 24 hours

By chrishindley ·
I am trying to show elapsed time in Excel which is very often over 24 hours. I want it to show only in hours, mins, (secs) I have seen some posts referring to using the time format of 37:30:55 but I cannot find this time format in my version of excel (2007). Am i looking in the wrong place or is there some way to use the custom format to make the spreadsheet do this. any advice welcome


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums