Calculate with time values
2000-02-04 Time 0 56
The function =NOW() can be used to return the current date and/or current time, depending on which number format you use in the cell that contains the function. The function returns a serial number for the current date.
The integer part is the serial number for the current date (see Dates for more details).
The decimal part is the time for the current day, and is calculated by dividing the hour by 24 hours. The hour 12:30 returns the decimal number 12.5/24=0.5208333.
||The current date and time|
||The date and time 12 hours later than now (24 hours/day)|
||The date and time 10 minutes later than now (1440 minutes/day)|
||The date and time 30 seconds later than now (86400 seconds/day)|
If cell A1 contains the hour
16:00and cell B1 contains this function:
=TIME(HOUR(NOW()),MINUTE(NOW()),0)then you can enter this formula in cell C1 to calculate the difference in time between the two hours:
=A1-B1Cell C1 must be formatted to display hours, not numbers.
A colon (:) is used as a separator sign between hours, minutes and seconds when you enter hours in a cell.
To convert an Excel timevalue to an ordinary decimal value you multiply the timevalue with 24. If cell A1 contains a weekly sum of working hours, you can calculate the amount of money you will get like this (assumes a rate of 250 dollars or pounds or kroner or whatever/hour):
=A1*250*24If you want to add timevalues greater than 24 hours you will have to use the custom number format [hh]:mm on the cells that you want to display timevalues greater than 24 hours.