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

Similar Threads

calulate working hours and minutes between 2 dates and times 9
Difference between dates/times in Days & Hours 2
How to calculate the number of days between two dates 2
Calculate Transaction Time Over Days 3
Calculating NetworkHours 5
Calculate number of hours between dates and times excluding Weekends 1
Difference between dates and times 5
Template for calculating different number of days between 2 dates 1

Top