elapsed minutes

[lezawang]

Hi
In this thread, Barry said "you can use [h]:mm. the same works for minutes and seconds.."
No problem with hours but with minutes, I do not see how it can be elapsed. I tried this code but did not work

[h]:[mm]

Thanks

https://www.mrexcel.com/forum/excel-questions/555898-difference-between-h-mm-h-mm-format.html

 

[Logit]

.
Barry was describing the format of the time ...

Are you now requesting code to make the time update in real time ? Or perhaps, calculating the difference between two times ?

 

[lezawang]

Yes that is right, both actually. Thank you very much.

 

[lezawang]

Just want to add this. I want to subtract 2:00am from 10:00pm

Starting time 10:00 pm
end time: 2:00 am

so total number of hours is 4. How can I subtract 2:00 am - 10:00 pm. Do I need to format the result cells as [hh]:mm first? It did not work? Thanks

 

[Logit]

.
When you are working with times that go past midnight, the best approach (and easiest for me at least) is to include the date with the times. Excel then
can determine you are speaking of times spanning two days. You can format the cell where the answer will be displayed to show only the hours/minutes.

As for a timer, here is a basic project :

Option Explicit


Dim SchedRecalc As Date


Sub Recalc()


With Sheet1.Range("H3")


.Value = Format(Now, "mm/dd/yyyy - hh:mm:ss AM/PM")


End With


Call SetTime


End Sub


Sub SetTime()


SchedRecalc = Now() + TimeValue("00:00:01")


Application.OnTime SchedRecalc, "Recalc"


End Sub


Sub Disable()


On Error Resume Next


Application.OnTime EarliestTime:=SchedRecalc, Procedure:="Recalc", Schedule:=False


End Sub


Sub clr()


Disable


Sheet1.Range("H3").Value = " "


End Sub

Place a 3 commandbuttons on the worksheet. One titled START ... one titled STOP ... and one titled CLEAR.

Have the START button connected to the macro : SET TIME

Have the STOP button connected to the macro : DISABLE

Have the CLEAR button connected to the macro : CLR

The macro is coded to display the date/time in H3.

 

[lezawang]

That is a nice project. I will spend time to understand it. Thank you so much. I appreciate it.

 

[Logit]

You are welcome.