Excel time formats
by volvogirl - 11/3/12 5:57 PM
Looked around under help but didn't see what I wanted. Using Excel97. I don't want a cell formated as time but I do want to format it as hh:mm:ss and be able to subtract, etc. But not as a date/time thing. My husband has been having trouble with his cell phone losing minutes and I made a spreadsheet to enter the call duration (which I think is since the beginning). So like Dialed Calls is currently 23:53:13. Don't know what it will show after 8 minutes? Will the hours increase? So what would the calculation formula be to subtract the prior duration amount from the current duration?