Time Conversion

  • Thread starter Thread starter Dastard
  • Start date Start date
D

Dastard

Hi
well i want to calculate the number of minutes present in this time
(123:45:06 ) "123 hours , 45 minutes and 06 seconds"
this is time is in one cell .. i need a formula to put in another cell
so that i can get the total number of minutes
Regards
 
Dastard said:
Hi
well i want to calculate the number of minutes present in this time
(123:45:06 ) "123 hours , 45 minutes and 06 seconds"
this is time is in one cell .. i need a formula to put in another cell
so that i can get the total number of minutes
Click to expand...

=A1*24*60
and format as number or general.
 
Back
Top