Calculating Time?

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi there,

what is the function to calculate hours?

e.g.:

Column A has 18:00

Column B has 20:00

Therefore the formula.function should return: 2 (hrs)


Many thanks,
neil
 
sorry, i should have also said - im want to delete 8 hours from my result,
but by simply just adding -8 doesnt work....it returns ######


Regards,
Neil
 
What do you mean? So you want a result to be -06:00
You have to set the date system to 1904 under tools>options>calculations
then use

=B2-A2-"08:00"

the default 1900 system won't return negative time values
if you insist you have to use another format like General and then use

=(B2-A2-"08:00")*24

to get decimal hours
 
Hi Neil
Ive had the same problem but if you try:

=A1-B1-1/3

This should work, you have to breakdown the day by the hours,
there are 3*8 hours in a day so you have to - 1/3.

Hope this helps

Chris Watso
 
Won't work unless you change the format and multiply by 24 OR change the
date system
 
Back
Top