Time Conversion

[Dastard]

Hi
well i want to calculate the number of minutes present in this time ( 23:45:06 )
this is time is in one cell .. i need a formula to put in another cell so that i can get the total number of minutes
Regards

[Bruce Fox]

Something along these line:

MsgBox DateDiff("s", "00:00:00", "23:45:06")

Yeilds: 85506 (Seconds sine midnight).

[Webtest]

Here is a step-by-step process to help you understand what you are trying to do ... convert a Date/Time value to a floating point number:

daysInteger.dayFraction

If daysInteger is 0, then the dayFraction * 24 = Hours and dayFraction * 24 * 60 = Minutes.

Option Explicit
Sub Macro1()
    Dim aTime As Date
    Dim myHours As Double
    Dim myMinutes As Double
    
    'Initialize a Date/Time value
    aTime = "23.49.22"
    'Convert to Hours and Minutes
    myHours = CDbl(aTime) * 24#  ' 24# = 24.0
    myMinutes = myHours * 60#    ' 60# = 60.0
    'Here are the results
    MsgBox myHours & "  " & myMinutes
    
End Sub

[Ecniv]

=(HOUR(B4)*60)+MINUTE(B4)+(SECOND(B4)/60)

B4 holding the time.

Wasn't a coding question - sounds more like a classroom question - using normal functions.

Code:

?cdbl(cdate("23:45:06"))*24*60

(same as webtests! - sorry!)