Converting Hours and Minutes


D

Dean Young

Can you please advise how to convert hours and minutes to
minutes also how to format the cells to accomodate the
information.
Thanks....
 
Ad

Advertisements

P

Peo Sjoblom

Custom format [mm], or if you need an integer

=A1*1440 format as general
 
Ad

Advertisements

H

Harald Staff

Hi

1 is a day, 24 hrs, in Excel (and Access, SQLserver and most MS things). So multiply time
with hours per day (24) or minutes per day (1440) to get the integer or decimal number.
Format result cell as decimal or General.
 

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.

Ask a Question

Top