Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hey guys I have a problem
I download call information into excel to make pivot reports. One of the fields is call duration. The format of the information is Minutes:seconds i.e. the call lasted 5:35 = 5 minutes and 35 seconds. Excel understand this as 5:35AM. This becomes even more problematic when I try and calculate total minutes, as excel sees it as 5:35AM + 12:02PM .... How can I make excel see this information as minutes and seconds and not "time" I've tried to convert the cells into text but all that does is give me the excel code version of time. This is an example of a line Date Time Origin Destination Duration 10-Sep 14:53 *** *** 08:51 ------- 8:51:00AM Thank you Josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time formats | Excel Discussion (Misc queries) | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
adding in time formats | Excel Discussion (Misc queries) | |||
US vs UK date and time formats | Excel Discussion (Misc queries) | |||
Calculate between two time formats | Excel Worksheet Functions |