Adding minutes

[nomad3d]

I can't figure out why this won't work. I'm not an excel expert, but I'm not bad with it, but this just eludes me.

Trying to do a simple call tracking sheet using the following columns:
Call Time Start Call Time End Length of Call Lenth of Time Between Calls Running total of downtime

I'll attach my sheet. Any help would be appreciated.

Thanks

Steve

[DBY]

Hello
Try replacing your formula in D3 down with the following:

=IF(A3="","",A3-B2)

Does this give the results you're looking for?

[JieJenn]

I tried to upload the file, but for some reason the forum won't let me. Anyway, in Cell D3, copy and this formula =TEXT(IF(OR(ISBLANK(A3),ISBLANK(B2)),"",A3-B2),"HH:MM") in E3 Copy and paste this formula and hit Ctrl + Shift + Enter to enter the array formula =SUM(--RIGHT(D3:D5,FIND(":",D3:D5)-1))

[JieJenn]

Oh never mind. I overthink this one lol.

[nomad3d]

Hello
Try replacing your formula in D3 down with the following:

=IF(A3="","",A3-B2)

Does this give the results you're looking for?

Thank you! Yes it does. I scoured the net for hours trying to get that. Thank you.