View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Murphy[_3_] Joe Murphy[_3_] is offline
external usenet poster
 
Posts: 1
Default 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.