• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Excel Problem

X

xTABx7

Gawd
Joined
Aug 6, 2004
Messages
731
I need to keep track of the duration of phone calls. They are generated delivered to me in text file and then I cop them into excel. The problem is Excel uses a time of day to represent the duration. like a 0:03:00 phone call is stored in excel as 12:03:30 AM even though it displays as 0:03:00. Thats fine when only working within excel but makes importing into access nearly impossible. Any suggestions?
 
maybe right click the cell and choose format cells...on the number tab its probably highlighted to time in category...choose the custom in the category list then scroll down the type column and you should be able to see an option to just display time in whatever function you need
 
You must log in or register to reply here.
Back
Top