Does someone have a script already written that outputs 365 mailbox sizes and archive sizes in GB as

Hello,

If anyone has the time to help I would appreciate your help for something that is beyond my skill set.   I spent hours on this with no luck

I can output mailbox sizes in GB with this script

Get-Mailbox -ResultSize Unlimited  | Get-MailboxStatistics |
Select-Object -Property @{label=”User”;expression={$_.DisplayName}},
@{label=”Total Size (GB)”;expression={[math]::Round(`
($_.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2)}}

I can output archive mailbox sizes with this script

Get-Mailbox -resultsize unlimited | Select-Object name, @{n="Archive Size";e={(Get-MailboxStatistics -archive $_.identity).TotalItemSize}},@{label="(GB)";expression={[math]::Round(`
($_.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2)}} | ft

I would like a single csv output with both the archive and mailbox sizes next to the person's name and in GB as the measurement.

This script will output both however it won't put them in GB. 

connect-msolservice
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session -DisableNameChecking  
Set-ExecutionPolicy RemoteSigned
Enable-PSRemoting


Write-Host "Gathering Stats, Please Wait.." 
  
$Mailboxes = Get-Mailbox -ResultSize Unlimited | Select UserPrincipalName, identity, ArchiveStatus 
  
$MailboxSizes = @() 
  
foreach ($Mailbox in $Mailboxes) { 
  
                $ObjProperties = New-Object PSObject 
                
                $MailboxStats = Get-MailboxStatistics $Mailbox.UserPrincipalname | Select LastLogonTime, TotalItemSize, ItemCount 
                
                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "UserPrincipalName" -Value $Mailbox.UserPrincipalName 
                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Last Logged In" -Value $MailboxStats.LastLogonTime 
                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Mailbox Size" -Value $MailboxStats.TotalItemSize 
                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Mailbox Item Count" -Value $MailboxStats.ItemCount 
                
                if ($Mailbox.ArchiveStatus -eq "Active") { 
                
                                $ArchiveStats = Get-MailboxStatistics $Mailbox.UserPrincipalname -Archive | Select TotalItemSize, ItemCount 
                                
                                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size" -Value $ArchiveStats.TotalItemSize 
                                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Item Count" -Value $ArchiveStats.ItemCount 
  
                } 
                else { 
                
                                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size" -Value "No Archive" 
                                Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Item Count" -Value "No Archive" 
                                
                } 
                
                $MailboxSizes += $ObjProperties 
  
}              
                
$MailboxSizes | Export-csv "C:\inboxsizes.csv" 
  
Get-PSSession | Remove-PSSession

I'm asking for someone who has a script or a fix for my script to assist please with the specific change to where in the script great!   If your solution is to learn scripting I appreciate the advice but it is unlikely I can come up with the solution.  

I tried the IT scripting guys forum and that was the response I got.