CONVERTING MINUTES AND SECONDS TO MINUTES ONLY


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
 
Ad

Advertisements

A

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
 
M

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
 
Ad

Advertisements


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