Change 60 minutes to 1 hour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nharris@jacksoncasino.com - 19 Apr 2007 22:38 GMT

I have a worksheet with a several fields that I place in minutes on
projects.
I need to total up the mintues to relect hours.
For example:
A1 , I have 54 minutes
A2 , I have 6 minutes
A3 , I have =SUM(A1:A2)

How do I get A3 to show total of 1 hour?

Reply to this Message

JE McGimpsey - 19 Apr 2007 22:46 GMT

One way:

=SUM(A1:A2)/60

If you want the result as an XL time:

=SUM(A1:A2)/(60*24)

or, equivalently

=SUM(A1:A2)/1440

format as time.

> I have a worksheet with a several fields that I place in minutes on
> projects.
[quoted text clipped - 5 lines]
>
> How do I get A3 to show total of 1 hour?

Reply to this Message