Forum Discussion
Time conversion
Try this:
=((B4-A4)-C4)*24
You will need to format the result (in D4 above) as a number rather than as a time. But that math works just fine.
The "trick" if it can be called that, is that minutes are stored as decimal fractions of the 24 hours. That's why the number that results from the figures in the parentheses needs to be multiplied by 24.
Try this:
=((B4-A4)-C4)*24
You will need to format the result (in D4 above) as a number rather than as a time. But that math works just fine.
The "trick" if it can be called that, is that minutes are stored as decimal fractions of the 24 hours. That's why the number that results from the figures in the parentheses needs to be multiplied by 24.
mathetes Thanks so very much for your prompt reply and answer. Its now working as I need it to.
You're a gem.