Date and time

[james rockford]

What I am looking to do is find the time it has taking to complete a task …So the work sheet has four cells (See below) and return the total time with cell E

Cell a Cell B Cell C Cell d Cell E
June 5 10:00 AM June 6 12:30PM ????

I hope this is clear and thanks for the help

 

[Rick Rothstein]

I somehow do not think you asked the question you really wanted to ask, but answering what you did ask, this formula will tell you the total number of hours between those two date/time values...

=24*(C2+D2-A2-B2)

Note: You will probably have to change the Cell Format back to General after entering this formula into a cell.

 

[james rockford]

Hi Rick,

I must be doing something in error because when I set up the formula it return #Valve
I have change the format to general as suggested but doing this there is no changes....HELP

a b c d
01-Jun 10:00am 01-Jun 10:00am #VALUE!
24*(C2+D2-A2-B2)

Again thanks for the help