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

  • Thread starter Thread starter lawandgrace
  • Start date Start date
L

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!
 
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.
 
Back
Top