Hi all,
I'm hoping to get help on utilising a formula that will allow me to add the duration of interviews as conducted by three different interviewers.
In the attached screenshot, I'm looking to have a formula along the lines of: if Column F = "MH", then add each corresponding interview time that appears in Column G.
Any help appreciated!
Thanks,
Jared.
hi there. probably a SUMIF:
=SUMIF(F:F,"MH",G:G)
https://www.youtube.com/watch?v=s-690XumAXU
if your hours exceed 24, you need to format the cells to be custom:
[h]:mm
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Excellent, thank you – that worked perfectly!
Jared.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks