CONVERTING MINUTES AND SECONDS TO MINUTES ONLY

  • Thread starter Thread starter bradsmih
  • Start date Start date
B

bradsmih

Hi,
I have a column displaying time in hours:minutes:seconds.
I have used the CONVERT function to change
hours:minutes:seconds to minutes:seconds, but I need to
display minutes only ie I need to round up or down to the
nearest minute. Can anyone out there help?
Thanks
 
I have a column displaying time in hours:minutes:seconds.
I have used the CONVERT function to change
hours:minutes:seconds to minutes:seconds, but I need to
display minutes only ie I need to round up or down to the
nearest minute. Can anyone out there help?
Click to expand...

Try something like

=INT(A1*60*60*24)

HTH,
Andy
 
Suppose you have date & time, or just time in cell A1. To extract the
minutes you could use:
=INT(MOD(MOD(A1,1)*24,1)*60)

Cheers
 
Back
Top