Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count time format as decimal
Hi all,
I was meaning to answer to a message from Tom, but of some strange reason I couldŽnt send it from the box, ( anyone no why?) So IŽll go this way instead. This is my questionreply "Hi Tom Thanks for your replay! IŽm sure it works fine, but can you help to translate it into the Swedish version, as IŽm getting a formula error. IŽve translated MOD as REST, but it seems like theres something more to be changed. Maybe IŽm using the wrong format?" Thanks, Thomas Tom Ogilvy" skrev i meddelandet ... assume 22:00 in B1, 01:15 in C1 in D1=MOD(C1-B1,1)*24*100 -- Regards, Tom Ogilvy |
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 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) | |||
count time format as decimal | Excel Programming |