Hi,
I need little help with a VBA code to calculate working hour.
Data is like here:
Start hour and end hour are in same cell (Alt+Enter)
Say in A2:A54 are data like this:
06:30 cell A2
15:25
---------
21:45 cell A3
06:30
--------
22:30 cell A4
05:45
-------
------=
13:35 cell A54
23:20
and result will be in cells (B2:B54) something like: 8:20, 11:15, 9:35 etc
Similar with this post but need to calculate hour passing hour 00:00
Collecting data from multiple rows in one cell
Thank you.