Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting time (hr:min) from date/time format
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting time (hr:min) from date/time format
Check out this reference...
http://www.cpearson.com/excel/datetime.htm#AddingTimes -- HTH... Jim Thomlinson "lawandgrace" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting time (hr:min) from date/time format
If you have a time/date in C2 you can get the time only by using this formula =MOD(C2,1) .....but what result do you expect from your data? The 2nd line has 2 different dates, don't you want to take the dates into account when calculating the difference? -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126433 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting time (hr:min) from date/time format
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" wrote: If you have a time/date in C2 you can get the time only by using this formula =MOD(C2,1) .....but what result do you expect from your data? The 2nd line has 2 different dates, don't you want to take the dates into account when calculating the difference? -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126433 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting time (hr:min) from date/time format
To get the number of minutes try like this =(D2-C2)*1440 format result cell as number -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126433 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting date from Date and Time formatted cell | Excel Discussion (Misc queries) | |||
Need help extracting date and time with Excel 2K | Excel Worksheet Functions | |||
Extracting specific data from Date and time strings | Excel Discussion (Misc queries) | |||
Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |