cancel
Showing results for 
Search instead for 
Did you mean: 

Mobile internet usage spreadsheet

JayAy
Dialled in

VM provide a less than useful format mobile internet usage csv file that using different MB,KB units  in the used column that makes it very difficulty to add up the true monthly usage.

JayAy_0-1672254380341.png

I'd like to be able to see the used amounts in a single unit without the silly bit of text in the filed too so they could be added together.

Does anyone have any excel magic that can do something like this?

1 REPLY 1

carl_pearce
Trouble shooter

Maybe:

Convert to MB

=NUMBERVALUE((IF(RIGHT(F2,2)="KB",((LEFT(F2,(LEN(F2)-2)))/1024),(LEFT(F2,(LEN(F2)-2))))))

SUM conversion

=ROUND(SUM(G2:G5),3)&"MB"