Calculate Hour & Minute

[faeiz2]

Hi all,

How do i get total hour and minute between two date and time i.e between
1130 am on 10/12/2003 and 8.45 pm on 13/12/2003.

tq.

 

[Dave Peterson]

Measured in hours and minutes?

Just subtract the smaller from the larger and give it a custom format of:
[h]:mm
or
[hh]:mm

 

[faeiz2]

Yes in hours & minutes. How about the different dates? let say I want to
know how many hours I work from 1 dec at 11:30hrs until 5 dec 22:00hrs. The
total hours and minutes.

Thanks a lot.

Measured in hours and minutes?

Just subtract the smaller from the larger and give it a custom format of:
[h]:mm
or
[hh]:mm

Hi all,

How do i get total hour and minute between two date and time i.e between
1130 am on 10/12/2003 and 8.45 pm on 13/12/2003.

tq.

 

[faeiz2]

Yes in hours & minutes. How about the different dates? let say I want to
know how many hours I work from 1 dec at 11:30hrs until 5 dec 22:00hrs. The
total hours and minutes.

Thanks a lot.

Measured in hours and minutes?

Just subtract the smaller from the larger and give it a custom format of:
[h]:mm
or
[hh]:mm

Hi all,

How do i get total hour and minute between two date and time i.e between
1130 am on 10/12/2003 and 8.45 pm on 13/12/2003.

tq.

 

[Dave Peterson]

I use USA dates (mdy).

I put:

12/01/2003 11:30 AM
in A1
12/05/2003 10:00 PM
in B1

and
=B1-A1
and formatted it for [hh]:mm
and got
106:30
back

(I could have entered the second date/time as:
12/05/2003 22:00
too)

Yes in hours & minutes. How about the different dates? let say I want to
know how many hours I work from 1 dec at 11:30hrs until 5 dec 22:00hrs. The
total hours and minutes.

Thanks a lot.

Measured in hours and minutes?

Just subtract the smaller from the larger and give it a custom format of:
[h]:mm
or
[hh]:mm

Hi all,

How do i get total hour and minute between two date and time i.e between
1130 am on 10/12/2003 and 8.45 pm on 13/12/2003.

tq.