# 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