Help! Time Calculation

[Kel]

All I want, is to display my time in total minutes, no hours, I.E. 1:30:00 would return 90:00.. any ideas?

Thanks!

Drk.

[Andrew Cronnolly]

Try =(HOUR(NOW())*60)+(MINUTE(NOW()))

regards,

Andrew C

[LegareColeman]

A few questions before I could answer this question.

If all you want is minutes, what is the :00 in your example? Do you want that to always be :00, or is that really seconds?

I do not know of a way to do this with formatting, therefore, I do not know of a way to display what you want in the same cell that contains the time. I can come up with a formula that will display what you want in another cell. Would that be acceptable? Can the times be more than 24 hours?

[Hans Pottel]

in Excel
if the contents of cell A1 is 16:48:00, then =Hour(A1)*60+Minute(A1) should give the total number of minutes in the specified time


in VBA

Sub test()
Dim tt
Dim MyHour
Dim MyMin
tt = Time
MyHour = Hour(tt)
MyMin = Minute(tt)
MsgBox MyHour * 60 + MyMin
End Sub

[Kel]

Great! Thanks! Okay, here's a tougher one..

Of those minutes, I want it to display a whole number, no time. I.E. 90:30 (mm:ss) would be 90.5.. any ideas? )

Thanks!!


Drk.

[Hans Pottel]

in Excel

= Hour(A1)*60 + Minute(A1) + Second(A1)/60

in VBA

Sub test()
Dim tt
Dim MyHour
Dim MyMin
Dim MySec
tt = Time
MyHour = Hour(tt)
MyMin = Minute(tt)
MySec = Second(tt)
MsgBox MyHour * 60 + MyMin + MySec / 60
End Sub

[Andrew Cronnolly]

if a time is in A1 then =((HOUR(A1)*60*60)+(MINUTE(A1*60))+(SECOND(A1)))/60 should do it. that returns the number of minutes calculated from the number of seconds. You can format it show how many decimal places you like.

Andrew C

[LegareColeman]

=A1*1440