Converting Hours and Minutes

  • Thread starter Thread starter Dean Young
  • Start date Start date
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....
 
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.
 
Back
Top