Time Difference

[AccessShell]

In a cell, can I use a formula to get the time difference (in Hrs and Mins) from two other cells. the start Time (i.e. 7:02 AM), end Time (i.e. 8:23 AM).

Thanks

 

[awoohaw]

Yes, format the cell as a date/time format using hh:mm.
But you will have issues you need to account for when it goes over midnight. In that case you'll need to use date values.
(to go over midnight, you need to input your time values including the date)

Book2
	A	B	C
1	Start Time	End Time	Elapsed Time
2	07:02	08:23	01:21
3	14 Nov 2023 23:15	15 Nov 2023 01:32	02:17
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=B2-A2

 

[AccessShell]

Thank you. I will study it. The times will never go over midnight. They will always be AM times.

 

[AccessShell]

Thank you. It works exactly as I need it to.

 

[awoohaw]

Happy to help! Best Wishes!