Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello. I have a simple spreadsheet that tracks my running. I enter the
miles run and elapsed time in two columns. The format in the time column is hh:mm:ss. Two more columns track cumulative distance and cumulative time. The format used in the cumulative time cell is d hh:mm. Once the total cumulative time reaches 31 23:59, the next cell returns: 1 hh:mm instead of 32 hh:mm. Am I doing something wrong? Many thanks. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Roll Under- sideways | New Users to Excel | |||
Roll Up | New Users to Excel | |||
auto number roll over? | Excel Worksheet Functions | |||
rent roll | Excel Discussion (Misc queries) | |||
trying to create a rent roll | Excel Discussion (Misc queries) |