A1*1440 converts the time to a number of minutes. Times are stored as a
fraction of a day so you need to multiply by the number of minutes in a day.
You will need to change the format of the cell with the result in as it
is likely to default to a time format.
Thank you for solving at least one of today's 'headaches' !
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.