Time Trouble

  • Thread starter Thread starter Jack Black
  • Start date Start date
J

Jack Black

I would like to put a date and time in A1 and a later date and time in
A2 and have B2 to show the difference between these 2 times in hours
to 2 digits .

Does anyone know how this can be done?


Thanks
 
=(B2-A2)*24
Click to expand...
Thank you, I get hours, minutes and seconds. What I would like is
hours only to 2 digits where 9:15 would show as 9.25.

Thanks
 
By my reckoning, if the result of B2-A2 is 9:15, it looks to me that my
formula does return 9.25. And isn't 9:15 hours and minutes anyway?
 
You must log in or register to reply here.

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

Formula for calculating time period between 2 dates 3
subtracting date and time to find the difference between the two 4
Difference between dates and times 5
Report data from cell if dates match 2
Difference between dates/times in Days & Hours 2
Length of time from date/time custom format 2
Difference between time in excel reported incorrectly 6
Negative time displaying as ##### 7

Back
Top