CODEWITHSUNDEEP
excelexcel-2010
oshirowanen
oshirowanen

Reputation: 15925

Getting hours between 2 dates

A1 = 29/05/2015 14:07
B1 = 01/06/2015 16:02
C1 = =(B1-A1)*24

Why am I only getting 22:00 in C1?

I was expecting it to count all the hours on the weekend too...

Upvotes: 1

Views: 31

Answers (1)

Pavel Gatnar
Pavel Gatnar

Reputation: 4053

either
A) adjust the formatting to number
or
B) do not multiply by 24 and simply adjust the formatting to [h]:mm

Upvotes: 3

Related Questions