Time calculations

D

durbat2

Hi I need a formula that will compare a time against a given reference
time of 16:00. For example 13:00 would return -3 and 18:00 would
return +2
The comparison time is formatted ddd hh:mm as it is part of a weekly
planning sheet but I need to check progress every day against a
reference time of 16:00

Hope thats clear

Martin
 
D

David Biddulph

=MOD(A2,1)*24-16 and format not as Date or Time but as General or Number, or
Custom Format such as +0;-0
 

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

Problem formatting dates from CSV file 2
Checking for date and time overlaps 0
Conditional Time Calculation 10
How to calculate difference between two date & time along with working hours and days 2
15 minute data to daily data 1
Calculating time for 3rd shift 4
HELP! I need to make an IF Statement comparing date/time fields.. 2
IF calculation of Time 2

Top