Calculate the number of hours between two dates and times

P

princy_varghese

I need to calculate the number of hours and minutes between two dates
and the time.
For e.g. 23.10.05 10:00 and 25.10.05 10:15. Does anyone knw how to do
this.
Thanks a lot

Princy
 
N

Niek Otten

=A2-A1 (If A2 is the largest)
Format Custom as [h]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to calculate the number of hours and minutes between two dates
| and the time.
| For e.g. 23.10.05 10:00 and 25.10.05 10:15. Does anyone knw how to do
| this.
| Thanks a lot
|
| Princy
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate number of hours between dates and times excluding Weekends 1
how can we calculate the numbers of hours between two dates and 4
Calc Number of Months PER YEAR Between Dates 2
Subtracting AD and/or BC dates 21
calculate the time between to dates and times 2
datetimepicker finding the hours between two dates 4
Excel Sumproduct 0
Time 6

Top