Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
232
Views
Topic starter
Hello
I have a table of hours calculations
I need help subtracting hours when one cell is a date and one cell is an hour
Column F has a date and time that is automatically obtained from a formula
In column G I need to calculate the figure from column F minus the figure from column C
Thanks for the help!!
LEA
Posted : 05/06/2024 6:55 am
Try this:
=MOD(F4,1)-C4
See attached.
Posted : 06/06/2024 1:08 am
Neat use of MOD !
Posted : 06/06/2024 6:47 am
Posted : 06/06/2024 7:57 am
