Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count time format as decimal
Hi all,
B1 C1 D1 Is there a way to count two timevalues (start 22:00 and stop 01:15=3:15). Get a value that works to multiply by i.e100, and receive the value 325? I´m using Chip Pearsons worksheetcode for converting "1000" into "10:00" and have the format as "t:mm" //Thomas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count time format as decimal
assume 22:00 in B1, 01:15 in C1
in D1=MOD(C1-B1,1)*24*100 -- Regards, Tom Ogilvy "Jonsson" wrote in message ... Hi all, B1 C1 D1 Is there a way to count two timevalues (start 22:00 and stop 01:15=3:15). Get a value that works to multiply by i.e100, and receive the value 325? I´m using Chip Pearsons worksheetcode for converting "1000" into "10:00" and have the format as "t:mm" //Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to type format time in decimal format & calculate | Excel Discussion (Misc queries) |