microsoft works or excel time formula

T

Tubs

I was wondering if anyone knew how to add time and dates together in works,
this is what I need,
If I leave the house on 6/25/03 at 14:00 and travel 56 hours is there a
formula that would tell me the day and time of arrival? I really need this
and would appreciate any and all help.
Thanks
Tubs
 
P

Paul Corrado

Cell A1 6/25/03 14:00:00
Cell A2 =52/24
Cell A3 =A1+A2

Excel recognizes hours as parts of days and each day has a value of 1

HTH

PC
 

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

Help with a formula for a Time Sheet. 1
Calculating the change in lead times from a table. 0
Work Budget Salary vs Real Time Salary 0
Problem formatting dates from CSV file 2
Calculate elapsed time excluding specific timeframe 10
Extract the 2 Lowest % 3
A couple questions BEFORE using Office 365 0
Conditional Time Calculation 10

Top