Calculate times between dates and times in Excel

H

Helio

How can I calculate the time in minutes between 2 events with format
(date,hour) or format date in a cell and time in another cell, without
weekends and holidays, for employees with 8 hours/day.
 
F

Fred Smith

It depends what you mean by "format (date,hour)". If they are true Excel
date/time cells, use:
=(a2-a1)*24*60
Format as a number

If they are not date cells, give us a sample of what they look like.

Regards,
Fred
 

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

Top