turning "1 day, 1 hour, 30 minutes" into 1530 minutes
I have a column of cells that contain day, hour, minute which is used to
determine how long it takes for a technician to accomplish a task in the
following format:
1 day, 1 hour, 30 minutes
1 day, 1 hour, 42 minutes
1 day, 1 hour, 52 minutes
but also includes cells that look like this:
1 hour
1 hour, 11 minutes
1 day, 57 minutes
What I would like to do is convert these cells into minutes only.
Maybe set a variable that sets
" day, " or " days, " to 1440
" hour, " or " hours, " to 60
"minute" or "minutes" to 1
and then multiply and put the result in the adjacent cell?
Maybe I'm going about this the entirely wrong way, but any advice would be
appreciated. Thanks.
|