I have a Created Time and and Ending Time which may well be different days (example below, created in green; ending in red).<TABLE style="WIDTH: 301pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=400 border=0 x:str><COLGROUP><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" width=129><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5046" width=138><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=129 height=17 x:num="39491.589004629626">2/13/08 2:08 PM</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 100pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=133></TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 104pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=138 x:num="39497.452245370368">2/19/08 10:51 AM</TD></TR></TBODY></TABLE>
I am looking to create the number of elapsed hours and minutes only in the results-- I can and have formatted the number of days, hours, minutes, seconds (as d:hh:mm:ss), but want the results to be ONLY in hours and minutes.
Any help anyone can provide would be much appreciated-- I have formatted the cells as dates (both in AM/PM and 24 hour clock format), with no luck so far...
Thanks!
Chris
I am looking to create the number of elapsed hours and minutes only in the results-- I can and have formatted the number of days, hours, minutes, seconds (as d:hh:mm:ss), but want the results to be ONLY in hours and minutes.
Any help anyone can provide would be much appreciated-- I have formatted the cells as dates (both in AM/PM and 24 hour clock format), with no luck so far...
Thanks!
Chris