T
Tom S
I am trying to get a formula that will give me time in tenths. For example;
20:30 to 09:00, should equal 12.5 I want the formula to use every 6 minutes
as a .1 I am using =MOD(C9-C8,1)*24 now. It changes at evey ten minutes to
a .1, so like 20:30 to 09:38 comes up as 13.1 and it should be 13.2 Every 6
minutes is a Point not every ten minutes. Can anyone help me with this??
I will also be using times from the same day, like 08:00 to 20:08 comes up
as 12.1 and it should be 12.2
Thanks
Tom
20:30 to 09:00, should equal 12.5 I want the formula to use every 6 minutes
as a .1 I am using =MOD(C9-C8,1)*24 now. It changes at evey ten minutes to
a .1, so like 20:30 to 09:38 comes up as 13.1 and it should be 13.2 Every 6
minutes is a Point not every ten minutes. Can anyone help me with this??
I will also be using times from the same day, like 08:00 to 20:08 comes up
as 12.1 and it should be 12.2
Thanks
Tom