Quote:
Originally Posted by ArviLaanemets
The easiest way would be entering start and end times as datetimes (like 13.11.2024 20:00). You can format time columns as "hh:mm", so your table looks all same, but the working time is calculated properly (unless you accidentally forget the date part of-course).
|
This looks good. After entering date and time as suggested in B1, say, in the second column(C1) enter =B1+1/24 and drag right. Format as suggested.
You will have to change your references to the first row as e.g. MOD(B1;1) instead of B1 to extract time
Is that what you want to do ?