Subtracting two time inputs on a spreadsheet and performing a mathematical equation

[Pookiemeister]

In Cell A1 I have text Start Time and Cell A2 I have text Now. Cell B1 contains the start time (manually entered) and cell B2 contains the NOW() function. Cell B3 subtracts the difference between cells B2-B1. All that works as expected. Now the issue, I need to take the difference convert it to its decimal equilvalent (i.e. cell B2-B1=3:42 or 3.7) and multiply it by 60 to get its minute equivalent. How can I achieve this?

Also, I have this snippet of code to Autoupdate the now function but I can't get it to format the current time to 24 hour time.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column <> 1 Then Exit Sub
    If Target.Cells.Count > 1 Then Exit Sub
    With Target.Offset(0, 2)
        .Value = Now
        .NumberFormat = "HH:mm:ss"
    End With
End Sub

Thank You

 

[JustynaMK]

Hi,

Taking the following values as an example:
Cell B1 -> 05/12/2018 10:30:00
Cell B2 -> 06/12/2018 12:07:44

The difference in cell B3 will be -> =B2-B1, formatted as [hh]:mm:ss, which will give you a result of 25:37:44
Now if you want to convert this result to minutes, you can enter the following formula into cell B4 -> =VALUE(B3)*24*60 (format as "Number")

As for your code, this is surprising as I'd think that "HH:mm:ss" should already give you 24h format. In order to get AM/PM format, you'd need to use .NumberFormat = "HH:mm:ss AM/PM"
Can you give us an example or extract of your data?