Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

how can i calculate the the number of hours and minits and second

between to times for example

=curren time(now) - 15:25:00 = total (h:m:ss)

As long as Now() is greater than the time you wish to deduct, you can

simply refer to the cells concerned.

ie: the source cell d1 contains your 15:25:00

the formula will be =now()-D1

You will need to ensure that the destination cell is formatted to the

required time format.

If however, you are spanning midnight you will need to adapt the formula

to:

=if(Now()>D1, Now()-D1, Now()+1-D1)

effectively the +1 is adding 1 day/24 hours.

Didn't find what you were looking for?
Find more on time calculation
Or get search suggestion and latest updates.

Related Topics:

- Time taken - Calculation
- Time difference calculations across midnight
- Constructors in calculation
- DISK SPACE CALCULATION
- User Function - is optional calculation possibe?
- adds =round(cell references,5) to allocate the calculation to 5 places
- Pivot Charts - Custom Calculations
- Pivot Tables Calculations
- Disabling Formulas, Not calculation
- Time Difference for Page Creation time
- Display character which appears number of time equal half of maximum time
- Access Time-out period.... Or session variable time limit?
- Access Time-out period.... Or session variable time limit?
- when i press the menu->display time the time must updates every second.
- On Error GoTo... Runs OK in the first time. But fails next time
- interesting agile time-estimating method
- do you know java source code for real time facedetection and recogin
- JAAS Authentication failiure at deploy time
- run time error
- Listener for time change
- Array Creation at Run time
- Causing timed form Post
- how to get the time of my machine
- Displaying 10 records a time
- cpu time