Problem Subtracting 30 Minutes From Value

[Ark68]

Staff2024.xlsx
	A	B	C	D	E	F	G	H	I	J
47	10	03-May-24	Fri	E1	Vacant	BPA	BPA	07:00	15:00	8.00
Student

Cell Formulas
Range	Formula
C47	C47	=B47
H47	H47	=B47+(7/24)
I47	I47	=B47+(15/24)
J47	J47	=(I47-H47)*24

Considering the data above, I am struggling to find a solution to reduce the value (hours) in J47 by 30 minutes.

I have tried both

=((I47-H47)*24)-time(0,30,0)
=((I47-H47)*24)-(30/1440)

with both giving me the same calculated value as 7.98. I was hoping for 7.5.

 

[FormR]

Hi, isn't it just :

=J47-0.5

EDIT: i.e.

=((I47-H47)*24)-0.5

 

[Fluff]

How about

=(I47-H47-TIME(0,30,0))*24

 

[Peter_SSs]

What about

=I47-H47-TIME(0,30,0)

24 01 30.xlsm
	A	B	C	D	E	F	G	H	I	J
47	10	03-May-24	Fri	E1	Vacant	BPA	BPA	07:00	15:00	07:30
30 Mins

Cell Formulas
Range	Formula
C47	C47	=B47
H47	H47	=B47+(7/24)
I47	I47	=B47+(15/24)
J47	J47	=I47-H47-TIME(0,30,0)

 

[Ark68]

FormR - Yes! This works.
Fluff - Yes! Of course that works to!
Peter - With a slight modification, yours works as well! (=(I47-H47-TIME(0,30,0))*24))

Thank you all for the quick response.

 

[Fluff]

Glad we could help & thanks for the feedback.