Extracting time (hr:min) from date/time format

[lawandgrace]

I have data that is in date/time format in columns C and D that I want to
extract the time only so I can subtract and find out the actual hrs/minutes.

Example of data:

Column C Column D
8/1/2008 3:30 8/1/2008 13:55
8/2/2008 1:30 8/5/2008 4:30

Thanks!

 

[Jim Thomlinson]

Check out this reference...

http://www.cpearson.com/excel/datetime.htm#AddingTimes

 

[barry houdini]

If you have a time/date in C2 you can get the time only by using thi
formula

=MOD(C2,1)

.....but what result do you expect from your data? The 2nd line has
different dates, don't you want to take the dates into account whe
calculating the difference

 

[lawandgrace]

My apologies. Yes, I do want to take the dates into account as well. What I'm
trying to do is get the actual number of minutes (subtracting column D from
column C) so I can figure an average time (I have over 300 rows of such
data). If I simply subtract column D from column C, where say 35 minutes
have transpired yet the dates are the same day, I get a result of 0.

Sorry for the inadequate description.

 

[barry houdini]

To get the number of minutes try like this

=(D2-C2)*1440

format result cell as numbe