REQ: time and hours minutes calculations

  • Thread starter Thread starter hassen_ben_soba
  • Start date Start date
H

hassen_ben_soba

Hi I am trying to setup a worksheet that when entering a time example
8:00am in one cell A 1 and 5:00pm in the next cell B1, it will
calculate total hours which will display in C1. Then calculate total
hours in column C1
Thanks in Advance
Joe
 
Hi
in C1 enter
=B1-A1+(B1<A1)
and format as hh:mm

To sum clumn C use
=SUM(C1:C10)
anf format the resulting cell as
[hh]:mm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TIME CALCULATION 5
Calculate elapsed time excluding specific timeframe 10
Excel Excel IF variable based on time of day 0
Calculate hours and minutes between times when it goes past midnig 9
Time Calculated minus breaks & lunch 2
Time Calculation 9
Conditional Formatting and cloring cells and date calculations 1
Format a TIME image in a cell 3

Back
Top