CONVERTING MINUTES AND SECONDS TO MINUTES ONLY

[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

 

[Andy Brown]

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?

Try something like

=INT(A1*60*60*24)

HTH,
Andy

 

[macropod]

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

 

[bradsmih]

Many thanks!
it worked when I did =INT(A1*60*24)

-----Original Message-----

Try something like

=INT(A1*60*60*24)

HTH,
Andy


.