Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to chart daily telephone hold times that are measured in minutes
and seconds (mm:ss) and then a cumulative sum for the day in hundreds of minutes and seconds (mmm:ss). I've tried using the custom number options, but they all seem to default the cell entry to a format I do not want. It seems I have to create my own formula, but haven't had success with that either. Any suggestions? (Also, if for the sake of easier data entry could be set up as mmm.ss that would be wonderful.) Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grand total time between two total cells | Excel Discussion (Misc queries) | |||
Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
Excel should format time down to the hundredth/sec. | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) |