Possible Text Conversion
for the first group of 7Days 19 hours 41 minutes, assuming that is an elapsed
time until the current time:
=NOW()-DAY(7)-HOUR(19)-MINUTE(41)
Paste the formula into a cell it will give you the date and time that the
count started.
"Rob" wrote:
How would it be possible to convert the below text into a number that Excel
will recognize as date/time?
Or...
How would it be possible to sum the below numbers given that it is
recognized as text by Excel?
7 days 19 hours 41 minutes
7 days 19 hours 41 minutes
1 days 9 hours 47 minutes
3 days 11 hours 20 minutes
12 days 0 hours 07 minutes
Thank in Advance. TOTALLY!
Rob
|