how do you subtract an hour or column value from a column which has a datetime format

how do you subtract an hour or column value from a column which has a datetime format
tatchis1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
Assuming you have time in A1 and hour in B1 then use this formula...
=a1-time(b1,,)
Saurabh...
0
 
Saurabh Singh TeotiaCommented:
Alternatively you can also use this...
=a1-(b1/24)
Saurabh...
0
 
TracyConnect With a Mentor VBA DeveloperCommented:
Assuming you have a date and a time in A1, then try this in B1:

=A1-TIME(1,0,0)
0
All Courses

From novice to tech pro — start learning today.