If 9:30 is in A1 and 12:45 in A2, the the formula
=A2-A1
will give 3:15
You may need to format appropriately.
If you want the actual number of hours as a number for further calculations
(i.e. in this case 3.25), multiply by 24 (and format as number or general).
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.
