Get instant live expert help on I need help with subtracting time in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I'm having trouble subtracting two date / time columns
Solved by C. J. in 16 mins
I am working in EXCEL with timecodes for TV. I need to be able to ripple an entire list of "in times" by adding or subtracting second increments. ex. segment time starts @: "01:12:15"- hrs:mins:secs", I need to change the in time by "04:" seconds, so it starts at "01:12:19", then I need to ripple all subsequents times by adding the ':04". Had a formula but lost it. Can you help me?
Solved by I. H. in 23 mins
I'm trying to have a cell turn red if it took more than 5 minutes to complete task. Column D is the result of subtracting B(time in) from C(time out). Ideally, there would be conditional formatting in column C that would turn red when over 5 minutes. However, I can't get it to work.
Solved by V. U. in 26 mins
I've calculated total hours worked in a shift by taking the current time and subtracting it from an employee's start time. Now I want to take the total dollars collected by that employee and divide it by the total hours worked I calculated to give dollars collected per hour but I keep getting $0/hr. Can you help me calculate this correctly in Excel?
Solved by K. Y. in 14 mins
To Subtracting two dates from two columns.
Solved by B. S. in 18 mins