I need Help with Excel Worksheet PLEASE

New Contributor

I'm currently trying to calculate an invoice using data that includes the following 


A (CALL DATE + TIME )   set up like ....  12/1/2017 8:47   and 12/1/2017 13:49

B (incoming call phone #)    customer #

C (work phone #)         same number, my #

D (duration on phone, seconds)   

E  (income call BEGINNING time  stamp, same as A column

F  (  Ending time stamp)

G  (whether or not it's incoming/outgoing call)


I am trying to figure out how to calculate Active hours. 

Answer phone call 8:34... end call at 8:46.... answer call at 8:54  = 2 CALLS, one active hour


Is it possible to calculate as such?

I've been trying to work on this but I'm at a stand still. 
please help! Thanks !


2 Replies

@JDExcel , better if you provide small sample file, removing all sensitive information, to illustrate how exactly your data looks like.


Active hours - if you have outgoing call starts at 8:59 and end at 9:01and now more calls at all - that's one call and two active hours to invoice?

@Sergei Baklan Yes that is correct. I don't know how excel works. I've only started using it today. I have extremely limited coding abilities. Do you know how I could create my excel to account for me? 

I'd greatly appreciate your time . 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies